Error in Bulk Copy 1

[JohnBates]

good morning,

I'm loading data from a text file.

Got this error that I can't really interpret.

What caused the failure?

Thanks, John


Bulk Insert: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature. [SQLSTATE 01000] (Error 4830) OLE DB error trace [OLE/DB Provider 'ST... The step failed.

 

[SQLDenis]

what did you specify for DATAFILETYPE?

[ [ , ] DATAFILETYPE [ =
{ 'char' | 'native'| 'widechar' | 'widenative' } ] ]

DATAFILETYPE value Description 
char (default) 
Performs the bulk copy operation from a data 
file containing character data. 

native 
Performs the bulk copy operation using the native (database) data types. The data file to load is created by bulk copying data from SQL Server using the bcp utility. 

widechar 
Performs the bulk copy operation from a data file containing Unicode characters. 

widenative 
Performs the same bulk copy operation as native, except char, varchar, and text columns are stored as Unicode in the data file. The data file to be loaded was created by bulk copying data from SQL Server using the bcp utility. This option offers a higher performance alternative to the widechar option, and is intended for transferring data from one computer running SQL Server to another by using a data file. Use this option when transferring data that contains ANSI extended characters in order to take advantage of native mode performance.

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[JohnBates]

Thanks SQLDenis. We just resaved the file and then it loaded error-free.