Looking for a possible solution. I have a database that has External Data Sources. Occasionally, one of the External Data Sources becomes disconnected momentarily (network fluctuation).
When this happens, is there a way to script in a reconnection? I thought maybe using a loop to make multiple attempts before exiting the script and use the OPEN DB script step, but once an already opened files becomes Disconnected, it seems that the OPEN DB doesn't work without manual intervention... which i need to avoid.
Thanks in advance for giving this some thought. I appreciate it.