Advanced Execute Process

Parent Previous Next


Advanced Execute Process Task


The "Advance Execute Process Task" is used to execute commands as if they were being executed from a command window. This allows for the use of basic commands like copy, ping, del, etc. as well as using any executable you would like to be executed within SSIS. One of the best features is it allows for multiple commands per instance of the task.



Steps


You are able to add multiple "steps" to the advanced execute process. A step is a single command that mimics what would be executed from the command line.


Toolbar


The toolbar is used to control the steps for the "Advanced Execute Process".


 

 Click to add a new Step to the Task

 

 Click to delete the currently selected Step in the Steps grid

 

 Click to edit the currently selected Step in the Steps grid

 

 Click to move the currently selected Step in the Steps grid up in the order of execution

 

 Click to move the currently selected Step in the Steps grid down in the order of execution


Add New Step


Clicking the "Add New Step" button will bring up the "Add New Process Step" window.



 Step Name - The name of the current step

 Step Command - The command in which this step will execute. The command can use any variables that are part of the package as replacement values in the command

 Timeout (Seconds) - The number of seconds you would like this step/command to run before the process is terminated. A value of 0 means there will be no timeout.

 Success Exit Code - The exit code of the command which indicates the step was successful. The default success code for the command line is 0.

 Window Style - The style in which a command window is shown. The four options are: Hidden, Normal, Minimized, and Maximized.

 Standard Output Variable - Choose to store the output to either a variable or command window

 Error Output Variable - Choose to store the error output to either a variable or command window

 Step Description - You can store notes about the step here. When you enter a description here, it will show up when the step is selected in the main UI as shown below.


Reordering the Steps


You can use the blue arrows in the toolbar to change the order in which the steps are executed.