SqlBulkCopy Tutorial - Knowledge Base (KB)

Issue with Oracle ODP.NET BulkCopy to Temporary Table

I'm using BulkCopy method from ODP.NET to insert a DataTable to a temporary table. If the temporary table is simple (no triggers or indexes) it works, fine, but as soon as I create an index or trigger, i get the "End-of-file on communication channel" erro...

AutoCommits OracleBulkCopy

C#.Net I am using OracleBulkCopy to copy data to global temp tables that are declared as Delete on commit. So when I use OracleBulkCopy.WriteToServer(DataReader). It commits and I am losing all the data. How to prevent this?

Oracle BulkCopy Type Matching

I am using SSIS for table transfers between different DBs. Since it is not specific to one source and target, and SSIS does not have dynamic column mapping itself, I implemented a script on C# by utilizing the OracleBulkCopy and SqlBulkCopy for writing to...