Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

Sharing Meta Data

SQL Server 2000

Data Transformation Services (DTS) Designer provides features for saving package meta data and data lineage information to Microsoft® SQL Server™ 2000 Meta Data Services. You can store catalog meta data for databases referenced in a package and accounting information about the package version history of a particular row of data for your data mart or data warehouse.

DTS Designer uses its own information model, the DTS Information Model, for structuring package meta data and data lineage information and saving it to Meta Data Services.

To browse the data lineage and meta data information generated by DTS Designer, use the DTS Browser found in SQL Server Enterprise Manager (available through the console tree, under Data Transformation Services, in the Meta Data node). This tool allows you to explore the meta data and version history of a package and to look up the specific package version that generated a row of data.

For more information, search under Meta Data Services at Microsoft Web site.

See Also

Saving a DTS Package to Meta Data Services

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.