SQL Server Metadata Toolkit is for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis.

A white paper that covers methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis.

A sample application:
1. Microsoft SQL Server 2005 Business Intelligence
2. Metadata Dependency Viewer and Analyzer Sample

Known Issues:
1. On an x64 windows platform you may find that some third party components are not recognised.
2. To address this copy the third party component DLL's from the 32 bit (C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents) folder to the 64 bit (C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents) folder. This may cause some unexpected side effects when you use these components, so I wouldn't be doing this on a production server.
3. The underlying issue is that the Application.PipelineComponentInfos on a 64 bit platform doesn't enumerate the 32 bit components.

The license of this software is Free, you can free download and free use this desktop publishing software.