Check Connection to DSN

Last Post 24 Apr 2007 04:19 AM by nbkr3bi. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

24 Apr 2007 04:19 AM
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

Acceptable Use Policy