SQL Server Integration Services: Prepare the data source files for Shared Storage connection

Prepare the data source files and store them in the folder that you created when you created the Shared Storage connection.

  1. Export the SSIS files for which you want to create a technical lineage.

    Tip You can export them directly from the SQL Server Integration Services repository or via Microsoft Visual Studio. For more information, see the SQL Server Integration Services documentation.

  2. Store the SSIS files to your local folder the Shared Storage connection folder. Typically, the folder contains the following files:

    • SSIS package files (DTSX), containing the SQL Server Integration Services source code.
    • Connection manager files (CONMGR), containing environment and connection information.
    • Parameter files (PARAMS), if applicable.
    Note 
    • If you use Collibra Platform 2024.05 or newer, ensure that you use the Edge CLI tool for creating the Shared Storage connection and storing files in the Shared Storage connection folder. Go to the following Create a Shared Storage connection step for detailed instructions. For more information, go to Edge Command Line Interface (CLI).
    • All files in this folder and subfolders are taken into account when you create a technical lineage. The lineage harvester (deprecated) Technical lineage via Edge automatically detects data sources in the SSIS files.
    • Not all SSIS files are processed and shown in the technical lineage. The lineage harvester (deprecated) Technical lineage via Edge retrieves all of the SSIS package files from the server, but only the files that contain lineage information, meaning those that contain a data flow, or Pipeline, are processed.

What's next

Add the Technical Lineage for SQL Server Integration Services (SSIS) capability for Shared Storage connections.