SQL Server Integration Services: Supported transformation details

Collibra Data Lineage collects metadata from SSIS packages (.dtsx), connection manager files (.conmgr), and parameter files (.params), if applicable, to build technical lineage.

Supported connection managers

Collibra Data Lineage parses the connection strings in SSIS connection managers to identify source and target systems. The following connection types are supported:

Connection type

How it appears in Collibra
Microsoft access (.mdb .accdb)

Maps the file name to the database name. If the value cannot be resolved from the connection string, the default value DEFAULT is used.
OLEDB, ODBC, and ADO Maps the user ID to the schema name. If the value cannot be resolved from the connection string, the default value DEFAULT is used.

If your technical lineage graph displays DEFAULT for a database or schema name, you can manually map these values to the correct assets by using the Source Configuration field in the Technical Lineage for SQL Server Integration Services (SSIS) capability.

Supported transformations and component types

Collibra Data Lineage supports the following non-exhaustive list of transformations and component types in SQL Server Integration Services:

Supported transformations

Supported component types
  • Aggregate
  • Cache Transform
  • Conditional Split
  • Data Conversion
  • Derived Column
  • Fuzzy Grouping
  • Lookup
  • Merge Join
  • Multicast
  • OLE DB Command
  • Row Count
  • Script Component
  • Slowly Changing Dimension
  • Sort
  • Union All
  • Microsoft.ADONETDestination
  • Microsoft.DataReaderSourceAdapter
  • Microsoft.ExcelDestination
  • Microsoft.ExcelSource
  • Microsoft.ManagedComponentHost
  • Microsoft.ScriptComponentHost
  • Microsoft.XmlSourceAdapter
  • PragmaticWorks.TaskFactory.HashTransform
  • PragmaticWorks.TaskFactory.UpsertDestination
Important