Using "Bulk Insert" in SQL 2000 with files containing data with Unicode characters often cause problems.
I tried to import data from a Unicode file to a nvarchar field using a format file with SQLNCHAR type. It ended up with no data transfer.
Here are the lines from my tries:
From .fmt file : 4 SQLNCHAR 0 255 "\r\n" 4 Text LATIN1_General_CI_AS
From Create table script: [Text] nvarchar (255)
TransactSQL: BULK INSERT Tuba TEMP FROM
'\\1994\IRIS\Queue\file10_10.txt' WITH (FORMATFILE = '\\1994\IRIS\Format\bcp.fmt' , FIRSTROW = 1 , ROWTERMINATOR = '' )
Simply changing the column type to ntext and using SQLCHAR in the format file, the data was finally transfered happily to my SQL Table.