MS SSIS Lineage Scanner
Scanned and supported objects
Scanned resources
The extracted metadata includes the following objects:
-
Folders
-
Projects
-
Packages and connection management files
Supported connectivity
-
Connector type: JDBC.
-
Authentication method: SQL Server Authentication using SQL login and password.
SSIS permissions
The user used for metadata extraction must have the following permissions:
-
SELECT
on tables and views of thessisdb.catalog
schema. -
EXECUTE
onssisdb.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. |
{
"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?