Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nbkr3bi
Starting Member
15 Posts |
 Posted - 2007-04-24 : 07:48:35
|
| 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 doesnt complete(succeed/fail) but just hangs up.We want to put in a check at the start of DTS to check if the connection succeds and if it fails, the DTS needs to fail.We need pointer as to how we can achive this |
|
|
|
|
|
Check connection to DSN