Microsoft SQL Server Integration Services (SSIS) is an ETL tool that extracts data from multiple sources, transforms, and loads them into different target databases. SSIS is a component of the Microsoft SQL Server database.
You can run connection-aware scans on Microsoft SQL Server Integration Services sources.
Objects extracted
Metadata Command Center extracts the following objects from an SSIS source system:
•Calculation
•Data Task
•Database
•Folder
•Package
•Parameter
•Parameter Container
•Procedure Definition
•Procedure Instance
•Result Set
•Result Set Calculation
•Schema
•Script
•Statement
Data lineage
The following lineage data is available for Microsoft SQL Server Integration Services assets:
•Data set level
•Data element level
•Embedded SQL
•SQL Task
•Stored Procedure calls
For more information about data lineage, see Data Lineage in the Working With Assets help.