• 0

C# sqlbulk insert


Question

I have used sqlbulk insert to initialy populate tables in the past. Can sqlbulk insert still be used in a process while checking that duplicate records are not inserted. I really don't want to do a line-by-line compare since my import files (delimited file) can containe a couple hundred thousand records.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

How are you generating keys?

If your unique index has IGNORE_DUP_KEY = ON, it shoud skip over that item. You'll probably still see a warning for it though.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.