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 |
|
pitmanfan
Starting Member
25 Posts |
 Posted - 2007-01-23 : 09:35:12
|
| i hope someone can help.i'm trying to set up a DTS that loops thru all the sql servers\instances and checks the size of the databases on each instance. i have a table with all the instance names from which i'm setting a global variable. i'm then using a dynamic properties task to set the server in a connection properties task. this will then do some work and loop back to the instance name table for the next instance. the problem i'm having is that on the 2nd run of the loop, the dynamic properties task doesnt change the server to the next instance. although if i run thru this manually, right mouse clicking and executing, it works perfectly. anyone know why the dynamic properties task doesnt work 2nd time around?thanksiain |
|
|
|
|
|
dynamic properties task not setting server name