July 15, 2009 at 2:32 am
Hello I am very new to SSIS,
I have managed to create a package that copies data from a source table to a destination table in my database.
Both table names are fed into the package through variables i.e. a source variable and destination variable.
This works fine until I change either variable to select a different table, once I do this I get an error and have to fix the mappings manually.
I am wondering if there is anyway for the package to automatically pick suitable mappings at run-time?
Ideally I will get this package in the future to loop through several source and destination tables.
Any help would be much appreciated, even if you can just tell me what to google, thank you.
July 20, 2009 at 3:09 am
Can anyone help with this please?
July 23, 2009 at 9:27 am
There's is no easy way to do what you're trying to do, at least not the way you want to do it.
You may want to try another possibility. Create a data flow for each condition you may encounter. Then add logic to determine which of these you need to execute. Use the Expression in your Precedence Constraints to determine which Data Flow will be executed.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply