SqlBulkCopy Tutorial - Knowledge Base (KB)

Error handling with SqlBulkCopy - could it be any harder?

Running very low on ideas here. I've got a case where I'm using SqlBulkCopy to pump data into a DB, and about halfway through I run into different exceptions (primary key violations, index violations, etc)....I've confirmed that the violations are in fact...

SqlBulkCopy - Importing XML data into SQL table

I'm having proplems with importing an XML file using ...SqlBulkCopy.... The XML file looks like this:... <root> <Automobiles> <Car Id="1" Name="SomeModel1"/> <Car Id="2" Name="SomeModel2"/> <Car Id="3" Name="SomeModel2"/> ...

Cut characters out of dataset before insert

I am running a sql query which stores results in dataset and then if dataset has rows it will run a query to insert into table. The problem is the data that is coming out is string and is saved as 001234 whereas I want the data to be stored in my table a...

How Transform OracleAdapter Dataset to SQL BulkCopy

I've successfully used the ...Oracle.ManagedDataAccess.Client... to fetch data from an Oracle server into a ...Dataset..., and used ...SqlBulkCopy... to insert that ...Dataset... into a SQL database where the tables have matching columns names (see below...