Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connection Manager - Assign Server Name during Runtime Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 11:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 13, 2014 6:17 AM
Points: 87, Visits: 403
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

Post #1567637
Posted Monday, May 5, 2014 12:24 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:52 PM
Points: 13,636, Visits: 11,509
Check out this article:

Continuing a Loop After an Error




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1567669
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse