I have a senario where i load data once a day from several databases via ODBC connections.(connectionstrings).
My problem is that this is a automated load process and sometimes when i have a problem with one connection the load stop to display connection error. What i would like is that if a ODBC connection is not successfull the load must carry on with the next connection of the following databases and skip the database that has a connection problem.
I was thinking in the line of :
IF connection1 success // HOW CAN I TEST CONNECTION WITHOUT HALTING ALL THE LOADS.