Execute Process Task

Process Task:-It is a task of SSIS package workflow basically uses to run application or batch of file. We can open standard application using execute process task like WinWord, Excel, and notepad etc we can use Process execute task to run custom .net executable file that generated reports or run business logic on database

When the Execute Process task runs a custom application, the task provides input to the application through one or both of the following methods:

· A variable that you specify in the StandardInputVariable property setting.

· An argument that you specify in the Arguments property setting. To pass multiple argument to a custom application in one execute process task use spaces to delimit the argument .An argument cannot include a space ; otherwise task will not run

Let start with example there will be two examples one will be normal in which we will execute Notepad file second will create custom application and pass single and multiple argument

A) Open Notepad File
Open BIDS as mentioned in previous article(Basic SSIS).
1) Drag Process execute task from toolbox into control flow editor.


2) Double click on “process execute task” present on control flow editor Process Task editor dialog window
will be open on General tab left pan enter “Open notepad” in name properties on right panel.



3) Select “Process” option on left panel on Executable properties enter “NotePad.exe”



Click on ok button

4) Execute package by clicking F5 notepad will be open

b) Custom Application

1) Create window application using below code snippet which will take two arguments and show it on message box

2) Go “Process” properties in “Execute process task editor pass exe path and enter

Parm1,parm2 in argument property use space to delimit the argument

3) Execute package using F5 button, message box will be shown in sequence

First argument value



Second argument value

How to use StandardInputVariable Property