0

I am using SQLBulkCopy to upload bulk data into Sql Table.. the table contains the column ID as Identity column. so it will not allow dulicate record as you know..

Consoder that I have 10 rows to insert by SQLBulkCopy, among that 10 records we have 2 dulicate rows...

My questions is: Is there any way to skip that duplicate rows while inserting rows using SQLBulkCopy?

Kevin M
  • 5,436
  • 4
  • 44
  • 46
  • Not easily See here http://stackoverflow.com/questions/1004525/sqlbulkcopy-error-handling-continue-on-error – G-Man May 14 '14 at 12:08
  • Have closed as duplicate. Please reopen if this does not solve your problem and specify what you have already done to solve it. This should include a reason why the linked duplicate is not duplicate. Using this site requires doing research *before* you ask. – usr May 14 '14 at 12:09
  • Staging tables are your freinds. – Dan Bracuk May 14 '14 at 12:12

0 Answers0