Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Serious Import problem

Author  Topic 

DrewBurlingame
Starting Member

49 Posts

Posted - 2001-09-20 : 16:57:15
I'm using DTS (SQL Server 2000) to import the contents of a CSV file into a table. It's been plugging along great for over a month now, but today I got some results I don't understand. When importing the file from today, it didn't start at the first row, which is essential for the rest of the process. Instead, it started near the bottom of the file and then looped around. So the bottom 4rth of the file is in the top 4rth of the table. Does anyone know what could cause this and what I need to do to make sure that DTS starts with the first line?

Thanks,

   

- Advertisement -