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