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)
 DTS not importing data

Author  Topic 

dowens
Yak Posting Veteran

82 Posts

Posted - 2008-02-06 : 13:16:55
Table has 3 field
ID length char 5, AnotherID varchar length 14, AccYr varchar length 6144

AccYr is the field that I have the problem with.
See data below the ü is a char(252) and ý char(253)

Some if these files populate and some do not.
I created another table for just this field (thinking truncating due to size) this did not help.


Text file being imported using DTS
total length 3041

AccYr looks like this:
01.2008ü02.2008ü03.2008ü04.2008ü05.2008ü06.2008ü07.2008ü08.2008ü09.2008ü10.2008

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-07 : 00:49:03
Which part was missing? Can you give some details?
Go to Top of Page
   

- Advertisement -