I am BULK uploading a CSV file into q SQL 2005 table
I am getting the following error
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 5, column 2 (name_1).
The reason is that one of the fields I am uploading contains the character / in the middle of a text field - when I remove this character the upload is fine - I wish to upload this text field with the / character - how can I do this ?
my code is
Bulk Insert #File01
Fieldterminator = ',' ,
FIRSTROW = 2,
rowterminator = '\n'