-1

I'm loading a data file to a SQL server database using bcp utility. There are some scenarios where while loading huge files, the load fails at mid way due to connectivity issues.

I can identify how many records are loaded in database. Assuming n records are loaded, is there a way we can resume loading of file in the bcp from n+1 th line instead of from the 1st line? Is there any parameter we can give in the bcp command to make this work?

jarlh
  • 42,561
  • 8
  • 45
  • 63
Arun
  • 65
  • 1
  • 9

1 Answers1

1

Yes. BCP has a -F parameter that will let you specify a 1-based offset. So, if you wanted to skip the first 1000 rows, you'd do:

bcp yourdb.dbo.yourtable in yourfile.bcp -F 1001 ...
Ben Thul
  • 31,080
  • 4
  • 45
  • 68