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