SQL Server Performance Forum – Threads Archive
Execute Process Task FailedI 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.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.