Skip to main content Skip to search Skip to main navigation
Contact

Microsoft SQL: SSIS Package Execution

Product information "Microsoft SQL: SSIS Package Execution"

SQL Server Integration Services (SSIS) is a platform for building data integrations and data transformation solutions.

This Universal Extension task interactively allows users to list and select the SSIS Folder, Project, Environment Reference, and SSIS Package while creating the job. Furthermore, it can trigger the SSIS package execution in the Microsoft SQL server, monitor the SSIS Package execution, and fetch SSIS logs to Universal Controller when the SSIS package execution has been completed.

Key Features:

This Universal Extension provides the following key features:

  • Dynamic Choice Fields to select the SSIS Folder/Project/Package/Environment Reference ID.
  • Launch SSIS Package execution. Monitor SSIS Package execution.
  • Fetch SSIS Package execution logs.
  • SSIS Execution ID and Execution status captured for every execution in the Task Instance.
  • Connection to MS SQL Server is done via the Python PYMSSQL module.
  • Supports Windows and Linux Universal Agents in order to connect to the MSSQL server.

What's New

Enhancements:

  • Added: support for SSIS execution parameter injection by introducing new array fields for package (package_parameters), project (project_parameters), and server execution (other_parameters) parameters, with dynamic SQL generation to apply runtime values during execution.
  • Rebundled the pymssql dependencies within the extension package to simplify deployment, improve compatibility across environments, and remove reliance on external package installation.


Extension Name: MS-SSIS-PACK-Execution
Universal Template Name: MSSQL-SSIS-Execution
Version: 1.1.0
Vendor: Microsoft
Type: Free
Compatibility : UC/UA 7.0 and above
Support: Community Created