Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Viewing Meta Data in DTS

SQL Server 2000

Data Transformation Services (DTS) allows you to view meta data in SQL Server Enterprise Manager (through the console tree, under Data Transformation Services, in the Meta Data node). You can:

  • Generate a hierarchical display of the meta data for any databases scanned to Microsoft® SQL Server™ 2000 Meta Data Services, and jump to information on the DTS packages that reference the meta data. If you regularly scan changes to catalog meta data, this display provides useful historical information on changes to the meta data. You can display the properties of a package version associated with any item of meta data, and a version history of those packages.

  • Retrieve the specific version and date of a package that populated a row of data. If you are tracking data lineage for a package, the DTS Browser lets you enter the lineage tracking number for a row of data to identify the package that created the row. For more information, see Recording Data Lineage in DTS.

  • Browse through package versions saved to Meta Data Services and update packages. You can display a version history of each package, view the properties of a selected package version, and open and update a package version.

© 2015 Microsoft