How to update column mappings dynamically??
-
Hello all,
I have a pckage that reads a list of tablenames, delete the tables, then copies the talbes from one db to another. I cannot figure out how to get the column mappings to update when the destination and source changes. It returns 'Column Name X was not found.' I have used the disconnect edit and see that the source and destination columns are update properly, it just isn't updating the column names and definitions.
Any help is greatly appreciated.
Thanks,
surefooted.
Surefooted
-
Are you using a list of tables because the tables to transfer can change from one exec to another?
-
Yes, I have a list of tables that I load into a recordset to pull from using an order by clause.
Surefooted
-
Do you modify the column mappings explicitly? If not then that's what you have to do. Basically you have to feed in all the Meta data that DTS automatically grabs when you're setting up the datapump task.
--------------------
Colt 45 - the original point and click interface
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply