Description:

This step executes an external Microsoft SQL server integration services (SSIS) package.

Usage:

Please refer to SQL Server documentation on how to setup SSIS external packages:

https://docs.microsoft.com/en-us/sql/integration-services/integration-services-ssis-packages?view=sql-server-2017

Example:

Let’s build and execute the “executeSSISExternalPackageDef” example.  

• Create a new definition called “executeSSISExternalPackageDef”
• Select the definition and click the “design” button
• Drag  the above controls to the designer canvas 
• Connect the dots between the steps as shown above
• Click on the “updateVariable” step to configure its “Settings” properties. Provide a name to the step

• Click on the “updateVariable” step to configure its “Advanced” properties. Provide a variable name. Provide the SSIS file path on the file server as variable value. Select “No” if the variable value is not an expression to compute.  

• The “Logging” setting configuration is necessary for documentation and also measure the workflow progress and the percent complete. This is acheived by configuring the step state and percent fields individually as shown in the images below. Configure the “Logging” using the following properties.

• Click on the “executeSSISExternalPackage” step to configure its “Settings” properties. Provide a name to the step. Provide the variable/global reference which contains the SSIS file path on the file server. 

• The “Logging” setting configuration is necessary for documentation and also measure the workflow progress and the percent complete. This is acheived by configuring the step state and percent fields individually as shown in the images below. Configure the “Logging” using the following properties.

• Save the process definition, create a new process instance and execute. 
• Render the process instance. Click on the process step. The step should execute external package.