I have a table where I have a list of sql servers in my network. I want to execute some statements in each sql server which are there in the table. I created a dynamic connection manager where I am assigning the "Server Name" property with the value from table.
Some of the servers are accessible and some may not have the rights to access. So I want the For each task to continue ignoring the connection issue for some of the servers and continue for servers that are having access. Is there any way to Ignore the error ?