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 components

CharacterMap
ConditionalSplit
DerivedColumn
FlatFileSource
Inserter
Lookup
ManagedComponentHost
Merge
MergeJoin
OLEDBDestination
OLEDBSource
RowCount
Sort
UnionAll

Limitations

SQL queries are excluded from the scan.

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 the ssisdb.catalog schema.
EXECUTE on ssisdb.internal.get_project_internal.

Scanner configuration

All fields marked with an asterisk (*) are mandatory.

Property Description

Property	Description
`name*`	Unique name for the scanner job.
`sourceType*`	Specifies the source type to be scanned. Must contain `SSIS`.
`description*`	A human-readable description of the scan.
`oneConnections`	List of Ataccama ONE connection names for future automatic pairing.
`jdbcUrl*`	The full JDBC connection string used to connect to SQL Server.
`username*`	The SQL Server or Active Directory user.
`password*`	SQL server user password.

name*

Unique name for the scanner job.

sourceType*

Specifies the source type to be scanned. Must contain SSIS.

description*

A human-readable description of the scan.

oneConnections

List of Ataccama ONE connection names for future automatic pairing.

jdbcUrl*

The full JDBC connection string used to connect to SQL Server.

username*

The SQL Server or Active Directory user.

password*

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?