MS SSIS Lineage scanner
Scanned and supported objects
Server side permission settings
The user used for metadata extraction must have the following permissions:
-
SELECT on tables and views of the ssisdb.catalog schema
-
EXECUTE on ssisdb.internal.get_project_internal
Scanner configuration
All fields marked with an asterisk (*
) are mandatory.
Property | Description |
---|---|
|
Unique name for the scanner job. |
|
Specifies the source type to be scanned.
Must contain |
|
A human-readable description of the scan. |
|
List of Ataccama ONE connection names for future automatic pairing. |
|
The full JDBC connection string used to connect to SQL Server |
|
The SQL Server or Active Directory user |
|
SQL server user password |
SSIS scanner example configuration
{
"scannerConfigs": [
{
"name": "SSIS Scan Connection",
"sourceType": "SSIS",
"description": "Scan SSIS project",
"oneConnections": [],
"jdbcUrl": "jdbc:sqlserver://mqlserver.database.windows.net;encrypt=true;trustServerCertificate=true",
"username": "admin",
"password": "@@ref:ata:[SSIS_USER_PASSWD]",
}
]
}
Was this page useful?