Home Dashboard Directory Help
Search

Is this an error in bcp format file? by asiaenforcer


Status: 

Closed
 as External Help for as External


0
0
Sign in
to vote
Type: Bug
ID: 402999
Opened: 1/20/2009 10:15:53 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Is this a limitation of BCP utility or the bulk insert?
This arrangement (three continuous lines) gives an error,
    1;a;b;c;d;e;f;; 2;d;e;f;g;h;i;; 3;g;h;i;j;k;l;;
    4;j;k;l;m;n;o;; 5;m;n;o;p;q;r;;
    6;p;q;r;s;t;u;;
This arrangement (one line) does not give error, it will insert all 6 rows,
    1;a;b;c;d;e;f;; 2;d;e;f;g;h;i;; 3;g;h;i;j;k;l;; 4;j;k;l;m;n;o;; 5;m;n;o;p;q;r;; 6;p;q;r;s;t;u;;

I do not know what row terminator to use to get all records, I have a suggest post ...
Details
Sign in to post a comment.
Posted by Microsoft on 3/18/2009 at 5:32 PM
Any updates on this? I realize you were not using the format file but try how the data file looks on bcp out and it will provide you a good clue.

I am resolving this but please feel free to re-activate if you are not satisfied

thanks
Sunil
Posted by Microsoft on 1/27/2009 at 11:56 AM
Here is what I will suggest to identify this issue quickly. Insert these three rows thru TSQL insert and then BCP out the data file using the format file and then compare it with your hand-crafted data file. you typically get this error when data file and format file have a mismatch.
Sign in to post a workaround.