Project DescriptionSQL Server Metadata Toolkit
MSDN's SQL 2005 tool kit updated to 2008 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.
This project is an update on the project released on MSDN Code Gallery
SQL Server Metadata ToolkitThe Database has been updated to handle longer names for attributes, and some views have been updated to handle SQL 2005 and SQL 2008 GUIDs.
There are enhancements to add Column names as Attributes, and with the Lookup, Fuzzy Lookup, Derived Column and Multiple Hash components, additional information is added to the Column name attributes.
The DependencyViewer has not been changed (other than updates to make it VS2008 compliant).
Alpha 2 has added handling for Containers, which was missing from the MSDN version. These are now recursively checked for Data Flows.
Alpha 4 now processes most SQL Statements to get the names of tables, and link these into the display.
Alpha 5 now includes additional handling for the Kimball SCD component.
Alpha 7 was a bug patch release which adds a number of new statements into the Parser. (CAST, EXECUTE, WITH CTE)
Alpha 8 was a functionallity release which added SQL Commands from Variables
Alpha 9 was a bug patch release which fixes cases where SSIS' AccessMode is incorrectly set (3 instead of 1). Also improves the EXEC parser. It also addresses the issue in previous versions not enumerating the SSIS Components when they are only installed in the x32 SSIS directory (as most component installers do).
Alpha 10 was a feature patch release, which adds the ability specify specific Integration Services folders within Integration Services (as opposed to the file system).
Alpha 11 is a functionallity release which adds an execution tool, Reporting Services analysis, Database analysis, and tweaks to the Viewer.
Alpha 12 is a feature patch release, which corrects the SQL 2005/2008 Reporting Services analysis (so it works), corrects the database create on the first run, so all tables and procedures are created, and adds the ability to scan only one analysis services database.
Known Issues:
The Executor doesn't have the option to change the SSIS server.
Example Screenshot
The following picture shows the output from this tool with stuff hidden to protect the innocent.
