Ssis Execute Process Task Hanging From Sql Server Job, No Errors Given

I have a basic SSIS package that has an execute process task which runs a .exe sitting on our NAS/Share drive which produces a csv file and is read by later steps. I can execute t

Solution 1:

If you are using your executable from a UNC path you will have to add it in the zone setting in Local intranet.

On your Internet Explorer, go to Security and select Local Intranet setting. Click on Sites and add your UNC path and click ok. The file:// protocol is added automatically.

This has nothing to do with SSIS, but everything to do with the zone settings in Internet Explorer.

This should help.