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: / \ : [ ] . =
Error: The result of the expression "@[User::ServerName]" on property "\Package\Loop thru Servers.Properties[Name]" cannot be written to the property. The expression was evaluated, but cannot be set on the property.
How can I get the connection to work for dynamic server names?