Skip to main content

Limitations and supported assets

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

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.
  • Upstream and downstream lineage within SSIS packages is currently not supported.

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