Using Microsoft Repository

DTS Designer provides features for saving package metadata and data lineage information to Microsoft® Repository, and linking those types of information. You can store catalog metadata 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 metadata and data lineage information and saving it to Repository.

To browse the data lineage and metadata information generated by DTS Designer, you can:

• Use the DTS Repository browser and viewing tools found in SQL Server Enterprise Manager (available through the console tree, under Data Transformation Services, Metadata). These tools provide a base set of capabilities to explore the metadata and version history of a package, and look up the specific package version that generated a row of data.
• Write your own external Repository tool capable of viewing package version data and metadata. To do this, you need to be familiar with Repository information models and programming to the Repository. For more information, see the Repository documentation supplied with Microsoft SQL Server™, and the Microsoft Repository Software Development Kit (available from the Web site http://msdn.microsoft.com/repository).