This content has been marked as final. Show 4 replies
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.
IF connection2 success
Help would be appreciated.