MS SSIS Lineage scanner

Scanned and supported objects

Resources scanned

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

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

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?