469,326 Members | 1,216 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Garbage at the RowEnd

hello Sir ,
I got some error while importing the data from .txt file to Sqlserver2000 database. The error which is produced while trying to import is :->

{ Bulk Insert fails. Column is too long in the data file for row 1, column 86. Make sure the field terminator and row terminator are specified correctly. }

the script i m using is :->

BULK INSERT cdr_try FROM 'C:\MSL20070408.txt'
WITH (
DATAFILETYPE = 'char',
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n')

Actually i think there r some garbage values in the txt file at each RowEnd.

Please tell me how to Remove garbage from the RowEnd so that the records can be placed in the dataTable.

Thanks with Regards,
Hemant Singh Adhikari
( New Delhi , INDIA )
( 09210282690 )
Apr 21 '07 #1
0 743

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

34 posts views Thread by Ville Voipio | last post: by
5 posts views Thread by Ben | last post: by
8 posts views Thread by mike2036 | last post: by
28 posts views Thread by Goalie_Ca | last post: by
56 posts views Thread by Johnny E. Jensen | last post: by
158 posts views Thread by pushpakulkar | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.