(Continuation of the Metadata 2.0 Series)
MetaShare does more than expose and help maintain your database metadata. It can also search your SSIS server for packages that are the source of the the columns in your dimensions and facts. By providing a folder on the SSIS server in which to search, MetaShare will automatically generate a document to display information about the column’s lineage inside that package. It lists the SSIS task name, task type, and the description as defined in BI Studio. Spending time and effort fully documenting SSIS packages becomes worthwhile because the data collected inside them becomes available to users.
Hopefully this can get a conversation going about how we can collaborate on our metadata and get it out where it needs to be – in front of the business users.