
DTS - importing CSV file drops last record
check out the following link
http://support.microsoft.com/support/kb/articles/Q247/3/60.ASP
Hope someone can help.
I need to import a CSV file into SQL Server 7.
The DTS package I have developed include VB to move the file over, and then
reads
the file into appropriate table format.
The problem is that every other app I read the file(s) into happily imports
all
the records. SQL Server/DTS consistently drops the last record.
Suggestions?
I could really use some help...
Thanks
if you're mailing me, just delete out "NOSPAM" from the address..
Steven