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)
 Problem importing text file with DTS

Author  Topic 

Munchausen
Starting Member

25 Posts

Posted - 2005-08-30 : 12:26:27
We've got a package that inserts a CSV text file into a table, but we're having a strange problem.

The last two columns in the text file are a varchar(2) and an int.

If both are null, it works fine. If they both have a value, it works fine. If the varchar has a value, but the int is null, the operation fails, as it doesn't see the last column.

So, this works:
,


And this works:
"BO",1


But this doesn't (it says we're missing the last column):
"BO",


We can obviously work around the problem by ensuring we put a column at the end which never has nulls, but we'd like to understand the root problem, in case it's affecting anything else.

Any ideas?
   

- Advertisement -