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.

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

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