transform data task processes half from source | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

transform data task processes half from source

I have a DTS package that just started doing this and hopefully someone can point me in a right direction to troubleshoot: I have a package that has a transform data task. This task uses activeX to copy from a flat file to a temporary DB. I have a flat file with 170k rows. It processes exactly half of them. I know that 170k isn’t a lot, but I broke the file into 2 65k files anyway. It prcessed 32500 of each of the 65K files. I then tried a file with only 22 rows. It processed them all. Anyone seen this before? Thanks!
SOLVED!<br /><br />For anyone interested, here was the issue:<br /><br />Originally the flat file was FTP’d to a directory on an NT4 server(Using the NT4 native FTP) The ftp was recently<br />integrated into the DTS package using the DTS ftp client. Apparently different versions of FTP can handle line feed/carriage returns differently. This resulted in the transformation part of the package incorrectly identifying when hte line was supposed to be a new row.Hope that helps someone else. It was certainly 4 hours of my life I will not get back. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />
]]>