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.