Solved

How to create Custom OLEDB Destination component in SSIS 2008 ?

Posted on 2011-03-22
3
638 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 250 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 250 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server - Sum Decimal Columns 11 43
SQL Server tables join on parse list 6 33
SQL Improvement  ( Speed) 14 33
sql 2016 Integration Service connecting to 2012 3 29
In this article I will describe the Backup & Restore 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.
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.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

765 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