I am having some difficulty understanding the MSDN documentation on the
useinternaltransaction option of the sqlbulkcopy class. It seems to say that
if this option is specified then each batch is placed into its own
transaction and then committed. If the batch fails then the batch is rolled
back. It is just not clear what the behavior should be if the option is not
specified. Is each batch not placed into a transaction. I set up a test and
whether or not this option is specified a batch that overlapps data in the
destination table is completely rolledback. Any explanation would be
appreciated.