Is this an error in bcp format file? - by asiaenforcer

Status : 

  External<br /><br />
		This item may be valid but belongs to an external system out of the direct control of this product team.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


0
0
Sign in
to vote
ID 402999 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/20/2009 10:15:53 PM
Access Restriction Public

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 ...
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.