...
Field Descriptions for 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 SSIS Universal Extension Tasks
SSIS Universal Task - Select DB Name
Select SSIS Folder Name
Select SSIS Project Name
Select SSIS Package
SSIS Execution - Task Instance
SSIS Execution Logs STDERR / STDOUT
Document References
This document references the following documents:
Name | Location | Description |
|---|---|---|
Python PYMSSQL Module Reference | Documentation about the PYMSSQL Module used in this Universal Task | |
Universal Extension | https://docs.stonebranch.com/confluence/display/UC71x/Universal+Extension+for+Universal+Controller | User documentation for creating Universal Extension Tasks in the Universal Controller user interface. |