Executes a SSIS internal package

Last published at: May 2nd, 2023

Description:

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

Inputs

  • targetserver – name of the SSIS server instance
  • folderName – name of the package folder
  • projectName – name of the project
  • packageName – name of the package 

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 executessisinternalpackageDef example.   

  • Create a new definition called “executessisinternalpackageDef”
  • Select the definition and click the “design” button
  • Drag an executessisinternalpackage step to the canvas
  • Connect the dots between the start and executessisinternalpackage step

  • Click on the “executessisinternalpackage” 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 the internal package.