Solved

How to create Custom OLEDB Destination component in SSIS 2008 ?

Posted on 2011-03-22
3
640 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

735 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