Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to create Custom OLEDB Destination component in SSIS 2008 ?

Posted on 2011-03-22
3
Medium Priority
?
661 Views
Last Modified: 2012-05-11
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...

Ajit
0
Comment
Question by:AJITPADHY
3 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 750 total points
ID: 35196213
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:

http://msdn.microsoft.com/en-us/library/ms141237.aspx

Are you trying to find instructions for something more particular?
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 750 total points
ID: 35196238
Have you seen this article: http://msdn.microsoft.com/en-us/library/ms135899.aspx

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.
0
 

Author Closing Comment

by:AJITPADHY
ID: 35390333
Thanxs
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question