SQL Server Performance Forum – Threads Archive

Execute Process Task Failed

I have three of these tasks in a package that run a batch to decrypt three different files. It’s been working fine until all of a sudden, one of them failed. The other two were decrypted successfully. Ran the package manually again, it was fine. What are the things I can look at to find out why that step failed when running automatically? Thanks

You will find all the logging and error reporting options on the "Logging" Tab of the "DTS Package Properties:…" dialog box in the DTS designer. These will allow you to see what’s up with your package in case of any hiccups. Nathan H.O.
Moderator
SQL-Server-Performance.com

Any changes on the privileges of SQLAgent or any recent application of hotfixes/service packs.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>