Dave Coats (8/10/2009)
cy.harrild (1/7/2008)
This is a great tool but i'm having a problem. It all works fine except that all the databases that the package finds throughout the network are listed against one server. Is this caused by the fact i'm building this on my workstation and not on the server?I'm having the same issue as cy.harrild. My dbo.database_status table only has info for the server I'm running the package from, instead of info for all servers on this domain. Looks like the loop is working because I'm getting the same 12 lines repeating for each server. Just seems that the loop is not grabbing the next server name into the variable SRV_Conn each time. ANy thoughts?
I figured out what my problem was. I had left out the step about configuring the Multiserver data connection. These are the steps I left out the first time:
Now we need to customize this connection
Right Click on MultiServer
Select Properties
Change the Following Properties
Expressions click ... box
Click Property
Click Drop Down Arrow
Select ServerName
In the expression box type @[User::SRV_Conn]
Click OK
Initial Catalog change to Master
Dave Coats