SSIS - For each loop through multiple servers

• tan110

  Hall of Fame

  Points: 3855

  More actions

  January 30, 2015 at 6:08 am

  #295043

  I have an SSIS job that dynamically loops through each server, grabbing data for typical DBA reporting, like diskspace, and errorlogs. If the server is down for whatever reason the SSIS package fails. Is there any way I can prevent the SSIS package from failing if one of the servers is down?

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  January 30, 2015 at 7:15 am

  #1774336

  Maybe you can quickly test a connection to a server in a script task before you try to read the data.

  If the connection fails, go to the next server.

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