I'm trying to loop thru several server to collect info about those instances.
My ForEach Loop Container is failing due to the \ in the server\instance name. The values are read in from a table
which contains MyServer\Myinstance for example.
Error: The object name "MyServer\MyInstance" is not valid. The name cannot contain any of the following characters: / \ : [ ] . =
How can I get the connection to work for dynamic server names?