Dynamic DTS transformation
Posted on 2005-04-19
I have a DTS package that needs to pump some data from one db to another, the problem is that the table names and columns are dynamically determined.
I have a table which contains all the table and column names that need to be transferred, its stucture is;
[table2] [column2] etc.....
I need some input on how to transfer this data, I tried to dynamically set the source and destination columns on the task via dynamic properties, but it seems this is not possible..