User Community Service Desk Downloads

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

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?