Did you changed the password in the connection of the actual dts package?

Tony Shamshad
Database Administrator
VOLARIS ONLINE
WK: 407-708-1700 x1954
MB: 321-662-5132

-----Original Message-----
From: Shawn Smith [mailto:[Email Address Removed] Thursday, August 08, 2002 3:58 PM
To: '[Email Address Removed] '[Email Address Removed] Interesting DTS problem here


Interesting DTS problem here.
We changed the password to an account we use to login to servers and such,
afterwards my dts would fail if used by the following exec
master..xp_cmdshell 'dtsrun /s circprod /u sa /p password /n
DTS_Preprint_BURT_CHKSUM_FILE'. I can run the DTS manually and from command
line. I even changed the password of the system account back to what it used
to be and it runs fine. Somewhere and somehow it is using the old password
and I can not figure out where. I have relogged onto the server and same
problem. What next?

Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page