SSIS (Files / Integration Services / Integration Services Catalog / Azure)

Version Supported: up to SQL 2022 

SSIS Method

In the Octopai Client, select the SSIS method implemented in your organization

SSIS Files

Warning: Missing permissions could end up in broken lineages.

SSIS Files Permissions Prerequisites

Read Permission for the Octopai Windows NT User to the SSIS folder containing the *.dtsx files.

• Read Permission for the Octopai Windows NT User to the SSIS folder containing the *.dtsx files.

Setting up SSIS Files Metadata Source

SSIS Integration Services

Warning: Missing permissions could end up in broken lineages.

SSIS Integration Services Permissions Prerequisites (Server Type: Integration Services - MSDB)

• Map the following users to the login used for extraction:

• Database ‘msdb’ with Database role membership db_datareader

• Database SSISDB with Database role membership public and ssis_admin

Setting up SSIS Integration Services Metadata Source

SSIS Integration Services Catalog

Warning: Missing permissions could end up in broken lineages.

SSIS Integration Services Catalog Permissions Prerequisites

• Database role membership to ssis_admin

• Grant read access permission to SSISDB.catalog.environments

Setting up SSIS Integration Services Catalog Metadata Source

SSIS Azure

Warning: Missing permissions could end up in broken lineages.

SSIS Azure Permissions Prerequisites

• User defined with a db_owner role on the SSISDB instance for the Integration Services Catalog.

Setting up SSIS Azure Metadata Source

Video - Extraction Guide

Watch the following video to learn about the SSIS Extraction process

How to verify the extracted Metadata File

Access the Octopai Target Folder (TGT)

1. Go to the TGT Folder located on the Server where the Octopai Client is installed.
   By default: C:\Program Files (x86)\Octopai\Service\TGT
2. Open the zip file having the Connector Name
   Example:
3. Verify its content
   Quantity & Quality of inner files

Troubleshoot

Error during the extraction:

• Check the permissions
• Send the log with the connector number and name to Octopai Support - C:\Program Files (x86)\Octopai\Service\log