We have a DTS that connects to a teradata server using a System DSN.
The issue is that the password for the ID used in the connection expires after every 2 months.
Whenever this happens, the DTS doesn’t complete (fail or succeed) but hangs up.
We want to put in a check at the start of DTS to check if the connection succeeds and if it fails, the DTS needs to fail.
We need pointers as to how we can achieve this
Thanks in advance