Helpful information and examples on how to use SQL Server Integration Services.
Elad Ziklik presented a great Data Quality Services session at TechEd last week, and it is now available online. The session covers the new DQS product that will appear in the next Denali CTP. He describes how to create a knowledge base and build up domain rules so that you can perform your own data cleansing. He mainly covers the use of the DQS client, and doesn’t go into details about the DQS Cleansing transform in SSIS. If you’d like to see it in action, I (briefly) covered it in my “What’s New in Denali” talk.
(click here for full size version)