DTS - importing CSV file drops last record 
Author Message
 DTS - importing CSV file drops last record
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



Sat, 29 Nov 2003 17:34:28 GMT
 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



Sat, 29 Nov 2003 22:39:01 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DTS-CSV file import with dangling comma after last column

2. DTS-CSV import file has dangling comma at the end of the record

3. Dts Import Question:Importing Csv file in an existing SQL2000 table with row-level conditions

4. SQL 7.0 DTS Import of CSV Files

5. Importing a 66 gigabyte csv file into SQL2000 using DTS

6. DTS import error from CSV file - cannot insert value NULL

7. Importing unicode CSV file via DTS

8. SQL 7.0 DTS Import of CSV files

9. Importing unicode CSV file via DTS

10. DTS import csv - dynamic file name

11. SQL 7.0 DTS Import of CSV files

12. SQL 7.0 DTS Import of CSV files


 
Powered by phpBB® Forum Software