Skip to main content

Limitations and supported assets

TL;DR

Learn about lineage support, limitations, and supported asset types for the Microsoft SQL Server Integration Services (SSIS) connector

Connect

Find answers to common questions about lineage support, limitations, and supported asset types for the Microsoft SQL Server Integration Services (SSIS) connector.

What lineage does the SSIS connector support?​

Atlan builds both table-level and column-level lineage from the source and target references in your SSIS data flow tasks. Each data flow becomes a process in Atlan that connects its sources to its targets, so you can trace a chain of packages end to end and run upstream and downstream impact analysis at either granularity.

Because lineage is built from the tables and columns referenced in your package files, SSIS lineage stitches into your wider lineage graph wherever those same assets are also cataloged by another connector — for example a Microsoft SQL Server source or a Snowflake target. Crawl those source and target systems as well so Atlan can resolve each reference to a cataloged asset.

For examples of each, see What does Atlan crawl from SSIS.

What are the limitations of the SSIS connector?​

  • Files can be accessed only through Azure Blob Storage.
  • When Azure tasks or components are included in SSIS packages, include the .conmgr file in the blob container along with package files.
  • Lineage depends on source and target assets already being cataloged in Atlan. Crawl the underlying source and target systems before you rely on SSIS lineage.
  • Table and column references that are resolved only at runtime — through dynamic SQL, package parameters, or variables — cannot be resolved during a crawl and do not produce lineage.
  • Custom or unsupported components do not produce lineage.

What SSIS asset types does the connector support?​

  • Containers: For Loop Container, For Each Loop Container, Sequence Container
  • Tasks: Execute SQL Tasks, Data Flow Task, Script Task, Azure Blob Upload Task, Azure Blob Download Task, Flexible File Task, Expression Task
  • Components: Lookup, Conditional Split, Data Conversion, Derived Column, MergeJoin, Sort, Union All, Aggregate, Azure Blob Destination, Azure Blob Source