SQL Server Performance

transform data task processes half from source

Discussion in 'SQL Server DTS-Related Questions' started by Jeffrey_D_York, Sep 16, 2004.

  1. Jeffrey_D_York New Member

    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!
  2. Jeffrey_D_York New Member

    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=':)' />

Share This Page