suppress windows security warning when running Execute Process Task/SSIS

Question

Post reply

suppress windows security warning when running Execute Process Task/SSIS

KoldCoffee

SSCoach

Points: 18971
More actions
June 27, 2014 at 2:23 pm

#287400

Using SSIS 2008. i'm executing psexe.exe from command line from within Execute Process Task. Executable and arguments all working fine but evertime I have to click 'Run' button on this dialogue box that pops up when the task is in a state of 'yellow' or it won't proceed. How to suppress this security warning? ie. "Do you want to run this file?" Name C:\Program Files\PSTools\psexec.exe, Publisher: Microsoft Corporation, Type: Application, ....."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

KoldCoffee SSCoach Points: 18971 More actions · Answer 1

found answer here

http://social.msdn.microsoft.com/forums/sqlserver/en-US/9f7df754-d766-49b8-833d-001d32217e23/open-file-security-warning

"It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog."