August 18, 2005 at 2:25 pm
I want to decide the source table and target table in a DTS job at runtime. This will enable me to use one job for transporting data from many sources to many targets instead of writing many jobs.
How can i do this?
August 18, 2005 at 2:43 pm
have a look on sqldts.com on using ini files to make the connections, there was also an article on this site.
August 19, 2005 at 2:42 am
DTS is nasty, but there is a relatively easy way to do this, although the more you do it the more complicated the package becomes. Use a global variable (other methods exist but this is the easiest) for your server, db, or table name attribute. Before your update/insert/delete step within the package, include a Set Properties step. This will allow you to set the properties of any step within the package. So for example you could set the server property on an Execute SQL step.
Hope this helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply