Running SQL Server 2008 Standard SP1 64 bit on a standalone machine running Windows Server 2008 R2. We receive a file that sometimes contains an extra CRLF at the end of the file. Integration Services will note a warning during manual execution,
Warning: There is a partial row at the end of the file. But the package will complete successfully and load all records from the file with the exception of the final record. This is
a tab delimited .txt file that we receive from a vendor which cannot be changed. If you manually remove the extra CRLF it loads all records, including the final record, with no problem. We installed the DTS runtime on another server to process
these files and as everyone knows DTS is much more forgiving and loads all records with no problem even with the extra CRLF present. However, with the investment we've put into SQL Server 2008 we would like to use SSIS rather than DTS. I've searched
this problem on the web but haven't had much luck in finding a solution. What needs to be done to correct this?
View Complete Post