A Bit More on Metadata

Metadata is defined as "data about data," and the Microsoft Metadata Services Repository contains the metadata for the server database objects, including packages.

You can use the Metadata or Metadata Services Packages view in the DTS section of Enterprise Manager to view database schema and to view the versioning and data lineage of a DTS package. Data lineage determines the source of a piece of data, and you can use DTS packages stored in the Metadata Services Repository to perform this auditing. You can then use the Metadata view to browse the lineage for a package execution, which will show the system name, account name, and date for every execution of a package that has lineage enabled. You enable data lineage in the Advanced options of the Package Properties page.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features