Data Access Technologies

(Data Access, XML, SSIS, LINQ, System.Data ...)

Calling SSIS Execute Process task from a remote batch file.

Calling SSIS Execute Process task from a remote batch file.

Rate This
  • Comments 3

This post describes an interesting scenario that I came across when working with a SSIS package developer. The main issue was that we were unable to run the SSIS package that contains a execute process task calling a batch file stored on a remote server machine (without being prompted by a warning window).

The following warning message window would pop up asking the user to either acknowledge the request or cancel it:

clip_image002

------------------------------------------------------------------------------------------------------

Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software ?

Name: Test.bat

Publisher: Unknown

Type: Windows Batch file

------------------------------------------------------------------------------------------------------

Because of this, when trying to executing the SSIS package through a SQL agent job, the job was doomed to fail if the user didn’t acknowledge the options shown by the security warning prompt.

Thus began our troubleshooting, where in, at first I verified that the user had the read-write-execute permission to the path where this batch file was saved.

Moving ahead, verified that UAC was turned off on the Server machine. Performing a simple test, we copied the batch file to the local machine and tried to execute the package from the Business Intelligence Studio. The package execution was successful and it didn’t bother to ask for a prompt.

Hence we clearly isolated the problem to be a permission specific issue. We also tried to set the command line parameter for the batch file with the switch " /C " , but it didn’t seem to help in anyway.

So this all trickled down to be a remote application permission launch issue. This is how we fixed the problem:

Launched Internet Explorer -> Internet options -> Security -> choose Internet -> Custom Level ->

clip_image004

Traverse up to Launching applications and unsafe files option and modified the setting (radio button) from the default value of "Prompt" to "Enable".

clip_image006

Now when the end customer tried to run the SSIS package from Business Intelligence Studio \ SQL agent , there was no warning being prompted when the execute process task tried to run a remote batch file. Thus the SSIS was package was now able to complete successfully.

 

Author : Ajay(MSFT), SQL Developer Engineer, Microsoft

Reviewed by : Jason(MSFT), SQL Escalation Services, Microsoft

Leave a Comment
  • Please add 3 and 8 and type the answer here:
  • Post
  • Thanks bunch You guys, this was very useful to me. This saved me from almost rebuilding my machine ( after repeated attempts to get my SSIS package working).

  • Great blog post. Strange you have to modify settings in Internet Explorer to get SSIS working :)

  • Thanks a lot it helped me a lot... :)

Page 1 of 1 (3 items)