SSIS Challenge Accepted!


Ms Kathy V


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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s