So, I had this issue for sometime now, where an SSIS scheduled from a sql agent job, would hang at a particular step and not run at all. We figured it was due to the exe and bat file in SSIS which needed a user prompt confirmation to go to next step. I had looked online if there was an option to suppress it inside of SSIS but dint find one.
Finally my manager pointed me to this solution:
"The publisher could not be verified" prompt running executable from network
http://www.annoyances.org/exec/forum/winvista/t1151260847
Problem:
Running XP SP2 or higher, you try to run an executable located on another machine
on your network. Your accosted with a prompt: "The publisher could not be verified".
You are forced to confirm that you wish to run this program... every time you run
it.
Solution:
Run gpedit.msc
Go to User Configuration >> Administrative Templates >> Windows Components >> Attachment
Manager
Add "*.exe;*.bat;" to the "Inclusion list for moderate risk file types" setting.
which I configured on the server that runs the package (as above)
and that fixed it! No more prompts.
Good Job..please keep the DBA fraternity updating..Aditya
ReplyDelete