I'm trying to create a package that goes to all sql servers and brings back information about those servers (ie, databases, jobs, alias names etc.) I'm using sqlrecon to gather all the servers to connect to (I tried using smo but I can't get the instance names to come back, just the server). My problem is that I don't have rights to all the servers from sqlrecon or some of them are have the sql server services stopped because they are no longer used.
The problem is when I'm looping through and setting my connection manager dynamically through variables if I cannot connect to one of the servers it fails. Is there a way in SSIS to test the connection and if I can't connect to skip it and go to the next entry in the variable to try to connect to that one?