For Each Loop - How to issue a GOTO statement within the loop?

• sxsanthanago

  Newbie

  Points: 3

  More actions

  August 4, 2008 at 2:54 pm

  #126900

  In my SSIS package, I have a For Each Loop which loops through a set of DBs located in different servers. The loop has a Script Task inside that sets the connection String for the server/DB dynamically.

  The loop will enumerate through Server1/DB1, Server2/DB2 etc.

  My requirement is to make the for loop continue through the list of the Servers specified though one of the connections fails.

  For example, if the Server2/DB2 is down, I would like the loop to still process and execute the Dataflow tasks for Server1/DB1 and Server3/DB3.

  Any help would be appreciated!

  Thanks!!

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  August 4, 2008 at 2:59 pm

  #852922

  Check this series of articles, does exactly what you want and logs any error to a table:

  http://www.sqlservercentral.com/articles/Integration+Services/61621/

  Andrew