The Execute Process task runs an application or batch file as part of a SQL Server Integration Services package workflow. Although you can use the Execute Process task to open any standard application, such as Microsoft Excel or Microsoft Word, you typically use it to run business applications or batch files that work against a data source.
For example, you can use the Execute Process task to expand a compressed text file. Then the package can use the text file as a data source for the data flow in the package.
As another example, you can use the Execute Process task to run a custom Visual Basic application that generates a daily sales report. Then you can attach the report to a Send Mail task and forward the report to a distribution list.
Execute Process Task Editor (General Page)
Use the General pageof the Execute Process Task Editor dialog box to name and describe the Execute Process task.
Provide a unique name for the Execute Process task. This name is used as the label in the task icon.
Type a description of the Execute Process task.
Execute Process Task Editor (Process Page)
Use the Process page of the Execute Process Task Editor dialog box to configure the options that execute the process. These options include the executable to run, its location, command prompt arguments, and the variables that provide input and capture output.
Indicate whether the task should fail if the executable is not found at the specified location.
Type the name of the executable to run.
Provide command prompt arguments.
Type the path of the folder that contains the executable, or click the browse button (…) and locate the folder.
Select a variable to provide the input to the process, or click <New variable…> to create a new variable:
Related Topics: Add Variable
Select a variable to capture the output of the process, or click <New variable…> to create a new variable.
Select a variable to capture the error output of the processor, or click <New variable…> to create a new variable.
Indicate whether the task fails if the process exit code is different from the value specified in SuccessValue.
Specify the value returned by the executable to indicate success. By default this value is set to 0.
Specify the number of seconds that the process can run. A value of 0 indicates that no time-out value is used, and the process runs until it is completed or until an error occurs.
Indicate whether the process is forced to end after the time-out period specified by the TimeOut option. This option is available only if TimeOut is not 0.
Specify the window style in which to run the process.