bypass a non existing server

• mtz676

  SSCrazy Eights

  Points: 9239

  More actions

  February 18, 2025 at 5:47 am

  #4540090

  I have an execute task(has server list from a table) pointing to foraeachloop

  foreachloop has dataflowtask which has oledb source and oledb destination

  Everything runs fine as long the servers are available.

  In case a server is removed and still exists in the execute task (table) the package fails.

  How can I bypass a non existing server in the Server table

  Thanks

   

• Phil Parkin

  SSC Guru

  Points: 247117

  More actions

  February 18, 2025 at 9:55 am

  #4540221

  Here is one way. There may be more elegant ways, but I'm short on coffee at the moment.

  • Create an SSIS variable 'ConnectionOK', or similar.
  • Add a script task before the data flow (but within the foreach container) which tests the connection and sets the SSIS variable depending on the connection status. There are several examples of the code needed to do this available if you do a search.
  • Finally, add a suitable (expression + constraint) precedence constraint between this task and the data flow, such that the data flow does not get executed if the ConnectionOK variable has been set to 'No' (or whatever).

  • This reply was modified 1 month, 1 week ago by  Phil Parkin.

  ---