Metadata Manager extracts metadata for different SQL Server Integration Services objects.
Metadata Manager extracts the following objects from a Microsoft SQL Server Integration Services resource:
Function
Macro
Namespace
Parameter
Parameters
Result Column
Result Set
Stored Procedure
Connection Manager Types
Metadata Manager extracts metadata for the following connection manager types:
OLEDB
FLATFILE
Control Flow Tasks
Metadata Manager extracts metadata for the following tasks in a control flow:
Data Flow
Metadata Manager displays a summary of each data flow that a package contains.
Execute SQL
If the SQL statement creates or truncates a table, Metadata Manager displays the table structure. However, Metadata Manager does not display data lineage for the table.
Transformations in a Data Flow
Metadata Manager can display a summary of the data flow when the data flow contains any of the following transformations:
Aggregate
Audit
Character Map
Conditional Split
Copy Column
Data Conversion
Derived Column
Export Column
Fuzzy Grouping
Fuzzy Lookup
Import Column
Lookup
Merge
Merge Join
Multicast
Percentage Sampling
Pivot
Row Count
Row Sampling
Script Component
Slowly Changing Dimension
Sort
Term Extraction
Term Lookup
Union All
Unpivot
Metadata Manager does not display individual transformations in the metadata catalog or in the data lineage diagram.