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

Prepare the data source files and store them in your cloud-based storage system. The files must be in one of the following:

  • An AWS S3 bucket.
  • An Azure Data Lake Storage container.
  • A Google Cloud Storage bucket.
  • An S3-compatible storage service.

  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. Upload the SSIS files to the bucket or container in your cloud-based storage system. Typically, the bucket or container should contain 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 
    • All files in this folder and subfolders are taken into account when you create a technical lineage. Technical lineage via Edge automatically detects data sources in the SSIS files.
    • Not all SSIS files are processed and shown in the technical lineage. 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

Create a Cloud Storage connection to the storage location where you stored your data source files. For guidance, go to the appropriate topic: