Microsoft recently released Master Data Services in SQL Server 2008 R2 CTP. Without getting into the strategic benefits, definitions, etc., MDM (Master Data Management) will be very helpful for any application in automating the setup and maintenance of look up or cross reference tables, hierarchies, dimensions, or utilizing reference data.
This article will provide an overview of Master Data Management and Master Data Services recently released with Microsoft SQL Server 2008 R2. In addition, a sample SSIS Package for loading data into the MDS Repository Staging tables will be provided.
To read this article in its entirety go to: http://www.sqlservercentral.com/articles/SSIS/69372/