Executes a SSIS external package

Last published at: May 2nd, 2023

Description:

Executes an external Microsoft SQL server integration services (SSIS) package.  

Inputs

  • packagePath – path to the package location within the file system

Returns

  • True
  • False 

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 a executessisexternalpackage  step to the canvas
  • Connect the dots between the start and executessisexternalpackage step 

  • Click on the “executessisexternalpackage” step to configure its properties
  • Configure the following values for the properties as shown on the below graphic

  • Save the workflow definition, create a workflow instance and execute. Step should execute external package.