hımm..
Earlier this week I posted about having a new challenge – how to use SSIS to dynamically define and generate rules for data cleansing. This week I discovered that the way to do this was NOT to do it! Instead of writing a custom set of code, I will be using SQL Server features Data Quality Service and Master Data Services to help import our data, and I will have SSIS call those packages to actually process the data. While I had known about these two features in SQL Server, I hadn’t had an opportunity to dig deep into what they do. I read about it this week and started playing with the tools, and I will be using them to help develop a non-code-driven data cleansing engine for my customer. By the end next week I should be an expert 😉
My customer aggregates data from various sources, and has no…
View original post 304 more words
analyzerhakan 