How can I get a Sql Server Bulk Insert to work when using a 'þ' as a
FieldDelimiter?
Executing the following statement against sql server 2005 is failing.
BULK INSERT aTest FROM 'G:/aTest.txt' WITH
(FIELDTERMINATOR='þ',ROWTERMINATOR='\n');
The error is this
Msg 4832, Level 16, State 1, Line 10 Bulk load: An unexpected end of file
was encountered in the data file.
If I change the FIELDTERMINATOR to a comma and I change the data file to
have a comma it works as expected.
Here's my data file (aTest.txt):
1þfirst
2þtwo
No comments:
Post a Comment