Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
isu-bando
Starting Member
1 Post |
 Posted - 2009-10-02 : 16:57:02
|
| I've read on other forums that having a truly dynamic data source in a data flow is not possible. Basically, this is due to the meta data being set at design time and SSIS not able to handle a change at run time. Previously, in SQL 2000, I had created a nice small DTS package where all I needed to supply was a list of tables for export, and the package would loop through the list and export the table data to a single MS Access file. It handled everything dynamically and remapped a Data Pump task as it looped on the table list. I am hoping to create this same small package in SSIS, and I've got everything else working just fine. However, I cannot find a way to dynamically set the source and destination data tables in the Data Flow task. It always dies on the one Data Flow task where I attempt to pull the data from the current table in the list. So, my question is has anyone found a way to reset the meta data at run time? I don't have a problem coding some wierd stuff if necessary in a Script Task, but I'm just too new to SSIS to be familiar with all the package objects and their associated properties/methods.Thanks for any assistance (including telling me it just cannot be done). |
|
|
|
|
|
Dynamic DB Source - Reset Meta Data