SQL Server Integration Services (SSIS)
On-premises (SQL Server) or Azure-SSIS IR.
Access mode: Read-only
Required information
| Field | Details |
|---|---|
| SSIS Catalog (SSISDB) | SQL Server hosting the SSISDB catalog database. |
| Project/package names | SSIS projects and packages to introspect. |
| Authentication | Same as SQL Server connection (SQL Auth or Windows Auth). |
| Access level | Read-only on SSISDB: ssis_admin role or SELECT on SSISDB catalog views. |
Network considerations
Same as SQL Server. SSIS metadata lives in the SSISDB database on a SQL Server instance.
Azure-SSIS IR: SSISDB hosted on Azure SQL. Same connectivity as Azure SQL.
Credential and auth management
Same as SQL Server connector. SSIS metadata is queried via SQL against the SSISDB catalog.
Permissions: SELECT on catalog.packages, catalog.projects, catalog.executions, and related views.
Package introspection: To read package XML/DTSX content, need SELECT on catalog.get_project stored proc or direct access to the internal tables.
Validation checks
| Check | Method | Expected result |
|---|---|---|
| SSISDB access | SELECT * FROM SSISDB.catalog.folders | Lists SSIS folders |
| Project listing | SELECT * FROM SSISDB.catalog.projects | Lists projects |
| Package listing | SELECT * FROM SSISDB.catalog.packages WHERE project_id = <id> | Lists packages |
| Execution history | SELECT TOP 5 * FROM SSISDB.catalog.executions ORDER BY start_time DESC | Returns recent executions |
Every connection starts from the pre-engagement checklist and goes through the universal validation protocol before production sign-off.