BUL:K INSERT OF UNICODE FILE
Posted on 2002-04-30
I am trying to use BULK INSERT to populate a table in a SQL Server 2000 database from a unicode file. I am using the following:
BULK INSERT tblTable FROM 'E:\File.txt'
DATAFILETYPE = 'widechar',
FIELDTERMINATOR = '\0',
FIRSTROW = 2,
MAXERRORS = 0,
ROWTERMINATOR = '\0\n',
but I'm getting an error - "Bulk insert data conversion error (truncation) for row 2, column 1 (fkColumnName)."
The same paramaters (except DATAFILETYPE) for BULK INSERT work fine when the file is ASCII. I have tried \0\0 for FIELDTERMINATOR and \0\0\n for ROWTERMINATOR but this doesn't work.
Anybody any ideas?