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)
 Error during transfromation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-09-25 : 07:28:14
Tasha writes "I'm trying to import a file that has numbers with dashes and some without. If I only import the file with dashes the file imports correct and the same without the dashes, but if I import the file with both I receive this error

Error during Transformation"Directcopyxform" for row number 1211. eerors encountered so far in this task;1 Transform copy"Directcopyxform' conversion error: Destination does not allow null column pair1 (source column" Amp Part Number" (dbtype_ra), destination column'amppar two' (dbtype_str)"
   

- Advertisement -