September 26, 2009 at 5:50 pm
Hie all,
I've been trying to import the CSV file with BULK INSERT. My Code is something like this,
--IMPORT.SQL
use wxy
BULK
INSERT dbo.CSV_Load
FROM 'C:\ss07husa.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\ n'
)
GO
With SQLCMD,
SQLCMD -S 192.168.1.68 -T -i import.sql
Now when i execute this code, i get error saying,
The bulk load failed. The column is too long in the data file for row 1, column
189. Verify that the field terminator and row terminator are specified correctly
I have confirmed that field terminator is ',' and row terminator is '\ n'.
So , Where I am wrong ?
Also , here , there is not SPACE between '\' and 'n' , I am just writing so because somehow i can not write them together here.
September 26, 2009 at 7:23 pm
This should help: http://support.microsoft.com/kb/935446
September 27, 2009 at 7:53 am
Thanksssssssss,
Its exactly what i was looking for.
BTW, i happen to have sql 2008 dev. edition too, which was giving me same error , any idea about it ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply