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

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