Capture OLE connection failure errors

• mtz676

  SSCrazy Eights

  Points: 9261

  More actions

  May 15, 2015 at 11:27 am

  #308137

  I have a list of servers saved in a Foreach ADO Enumerator in a Foreach loop in SSIS.

  How do I capture Database connection failure errors.

  Ex:

  I am using select @@servername to check if the database instance is up and running

  How do I capture OLE DB connectivity errors.

  Thanks

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  May 16, 2015 at 4:07 pm

  #1798461

  metroman17 (5/15/2015)

  ---

  I have a list of servers saved in a Foreach ADO Enumerator in a Foreach loop in SSIS.

  How do I capture Database connection failure errors.

  Ex:

  I am using select @@servername to check if the database instance is up and running

  How do I capture OLE DB connectivity errors.

  Thanks

  Quick question, what is the end goal here?