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