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 in V1.0.4
This new release involves a minor bug fix.
| Extension Name: | MS-SSIS-PACK-Execution |
|---|---|
| Universal Template Name: | MSSQL-SSIS-Execution |
| Version: | 1.0.4 |
| Vendor: | Microsoft |
| Type: | Free |
| Compatibility : | UC/UA 7.0 and above |
| Support: | Community Created |
Please visit this link to find key features, prerequisites, installation instructions, configuration instructions, and examples of how to use this integration.