Custom SSIS Destination Adapter for Bulk Insert

Question

Hi,

I am trying to build a custom SSIS component which combines the functionality of Conditional split transformation and OLEDB Destination Fast Load. in theory, I want to pass a variable to my component and that variable will control my component whether it should run or not according to its value. I am reading http://media.techtarget.com/digitalguide/images/Misc/sqlserver_ch14.pdf and http://msdn.microsoft.com/en-us/library/ms135899.aspx but I don't know how to call up the Bulk Insert command from my code.

Thanks in advance for your expertise.

Answer 1

I'm not sure if this will help, but a blog post shows how to use the SqlBulkCopy class in the .Net framework for bulk insertions.