SqlBulkCopy Tutorial - Knowledge Base (KB)

SQL Server .NET SqlBulkCopy class keep running after exception

I'm inserting lot of data with a SqlBulkCopy. The source of the data may have some duplicated rows. I the destination table I have an index of uniqueness....When the first duplicated row appears, the SqlBulkCopy throws an exception and rollback the intern...

Cannot access database through linked server

I am using the SqlBulkCopy Feature to store bulk data in to Sql database....For Ex: bulkCopy.DestinationTableName = "employeetable". This code works fine. But In a scenario, where i don't have access to the Destination database directly through Connection...