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.