SSIS Data Flow - Custom Data Source
-
Hi there,
I've been looking around for a bit to find a good starting point for my problem and have not found anything too helpful. It's probably my lack of understanding more than anything so hoping that someone here could assist.
In my SSIS package I have a need to dynamically (at run time) identify some tables to copy from one database to another and those databases may not be on the same server.
In my SSIS package at run time I determine what tables need to have data copied from one database to another and store that list of tables in an object variable.
So I've got a for each loop looping through that object variable with all the table names in it. What I need to do is copy data based on the table name variable from one database to another database. So I can't create static data flow source and destination objects in a data flow task as the different tables have a different amount of columns, names, data types etc. So I figure I need to do this with a script component source and a script component destination.
I've attached a picture which shows the objects in my SSIS package and everything works correctly up to the point that I've highlighted.
I've looked at the link but I'm more after a step by step guide that I can follow. I've got a rough understanding of C# and VB.Net so I'm no expert but very willing to learn.
Can anyone recommend a good resource for this please?
Kind regards,
Chris
-
Although it may seem as though the script components offer infinite flexibility given enough code, your problem will be that the input and output columns are defined at design time.
I have not used it personally, but if you are open to using third-party components, you may find this of interest.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply