...
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.
Import the Microsoft SQL: SSIS
...
Universal Extension Task Template
To use this downloadable Universal Template, you first must perform the following steps:
...
When the files have been imported successfully, the Universal Template will appear on the list. Refresh your Navigation Tree to see these tasks in the Automation Center Menu.
Configure Microsoft SQL: SSIS
...
Universal Extension Tasks
For this Universal Extension Task type, create a new task and enter the task-specific Details that were created in the Universal Template.
Field Descriptions for Microsoft SQL: SSIS
...
Universal Extension Task
Field | Description |
MSSQL Server Name | IP address or Host name of the MSSQL Server. |
MSSQL DB Credentials | MS SQL server credentials for accessing the Integration service Catalogs and SSISDB privileges to create temporary stored procedures. |
MSSQL Database Name | Dynamic choice field to select the database , Default value would be SSISDB. |
SSIS Folder Name | Dynamic choice field to select the SSIS Folder. |
SSIS Project Name | Dynamic choice field to select the Project Name. |
SSIS Package Name | Dynamic choice field to select the SSIS Package. |
Environment Reference ID | Dynamic choice field to select the associated Environment Reference ID for the selected SSIS Package. |
Fetch SSIS Package Logs | If True, then the SSIS execution logs would be fetched to Universal Controller (STDOUT). |
SSIS Execution ID | Output-only text field visible only in task instances; provides the SSIS Execution ID. |
SSIS Execution Status | Output-only text field visible only in task instances; provides the SSIS Execution status from MSSQL server. |
Examples of Microsoft SQL: SSIS Universal Extension Tasks
SSIS Universal Task - Select DB Name
...