Solved

How to create Custom OLEDB Destination component in SSIS 2008 ?

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

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…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

737 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