Connection Manager - Assign Server Name during Runtime

  • Hi All,

    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 ?

    Chelladurai

  • Check out this article:

    Continuing a Loop After an Error[/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply