October 4, 2005 at 2:19 pm
Is there an easy way to change the destination in multiple tasks at the same time without doing it manually for each transform data task?
October 5, 2005 at 8:34 am
Yes there is. Add an activex task and write vb script to create pkg object and loop thru all the task and their properties to change them.
October 5, 2005 at 8:42 am
Do you have any example code that you've used before?
October 5, 2005 at 9:14 am
I take it to mean that you want to switch to an identical table on another server.
Best way is to use the configuration ini file. This is the best article out there to get you started:
http://www.databasejournal.com/features/mssql/article.php/3073161
October 5, 2005 at 9:18 am
Thanks Jonathan that's just what I needed!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply