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)
 BULK INSERT using format files

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-13 : 19:32:16
Henry writes "I have a table XYZ (nvarchar, binary) and a unicode (widechar) datafile from which i want to upload data into the table. When I use the BULK INSERT without a format file data is getting uploaded into the table. However if I specify a format file ( created by bcp ) its giving an error that "implicit conversion from nchar to binary is not supported".
Is it that format files cannot be used with unicode data files or is there something else that needs to be done to upload data ?"
   

- Advertisement -