Microsoft SQL Server Integration Services (SSIS) is an ETL (Extract, Transform, Load) 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.
Objects extracted
Metadata Command Center extracts the following objects from a Microsoft SQL Server Integration Services 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 the Asset Discovery help.