O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18. Data Lineage

Data Lineage

Starting with Microsoft SQL Server 7.0, Microsoft included the Microsoft Repository for storing and managing meta data, models, components and objects for reusability, interoperability, team development, data resource management, and dependency tracking. The Microsoft Repository is known as Meta Data Services in SQL Server 2000. By using Meta Data Services, you can track the source, transformation, and destination of the data used in the package over time. You will find this capability very useful with data warehousing (refer to chapters 11, 12, and 13). Data lineage that is stored via Meta Data Services can be used to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required