Execute Process Task Failed | SQL Server Performance Forums

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.
Any changes on the privileges of SQLAgent or any recent application of hotfixes/service packs.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.