SQL Server Performance Forum – Threads Archive

Bulk Insert Error……

Hi Gurus,
I used Bulk Insert statement to transfer Flat file data to a Table of the
Database.I encountered following …… BULK INSERT pubs..Subscriber FROM ‘c: ransferdata.txt’
WITH (
DATAFILETYPE = ‘char’,
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘
‘, ) Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 11, column 1 (MSPPID).
Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 149725, column 14 (SubscribersEmailAddress).
Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 149770, column 7 (Country).
Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 149794, column 15 (ShipToPostalCode). What is the cause for such an error and How to Fix it. Please help very Urgent. raj

Check compatibility between columns table and txt fields.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Hi Gurus, Ok, I fixed the Error for typemismatch.But still I am facing problems with some
rows.How to treat them as rejected Rows and continue with the transfer. currently I am unable to transfer any rows.there is no data transfer. can I have links on BULK TRansfer,prefereblely with examples. Please help. raj

After importing data delete the unwanted rows Madhivanan Failing to plan is Planning to fail

Have a read about BULK INSERT and BCP topics under books online. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>