How to create Custom OLEDB Destination component in SSIS 2008 ?

Guys ,
     Anyone knows how to create a Custom Dataflow OLEDB Destination Component in SSIS. Please revert back with a sample code whixh will be very helpful to me !!!

Thanks in advance...

Who is Participating?
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
Are you trying to do something special, or just open a connection to an OLEDB-compliant database as the destination for your data? If you're just creating the connection, here's Microsoft's explanation of what's involved:

Are you trying to find instructions for something more particular?
ValentinoVConnect With a Mentor BI ConsultantCommented:
Have you seen this article:

It gives you a good idea of what methods that need to get implemented when creating a custom destination component.  How you implement them is up to you, so if you want to write data to an OLE DB destination, you should be able to do that by using the objects in the System.Data.OleDb namespace.
AJITPADHYAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.