Viewing 5 posts - 16 through 20 (of 20 total)
Thank you all, I figured out where FIRSTROW is supposed to in.
August 27, 2008 at 12:03 pm
Jeff:
results from the print statement:
BULK INSERT SALES.GBDS_JOLM_ORDHDR FROM "g:\DATA\BCPTEST.csv" WITH (FORMATFILE = "g:\data\JOLMHDRFMT.TXT")
David: where do you put FIRSTROW=2 to ignore the first row in the format file?
after 9.0 ? Would...
August 27, 2008 at 11:17 am
Jeff: Thanks for the response.So now my format file looks like this:
9.0 ...
August 26, 2008 at 1:04 pm
Jeff: Great post-even though this was 3 years ago. I am hoping you can help me with my bcp issue. My file looks like this
"RECORD_ID","SOURCE_ID","MEDIA","CREATED_BY","DATE_ORD","ORD_TIME"
"MLMORD20140571","7499582HG","GVAUTO","",20080616,"02:21:08...
August 25, 2008 at 3:34 pm
Simon: Were you able to resolve the issue? I also followed Jose Alves's instructions and am getting the same error as you.
Would appreciate any help in this matter
August 19, 2008 at 9:31 am
Viewing 5 posts - 16 through 20 (of 20 total)