User Community Service Desk Downloads

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

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?