Browse by Tags

Tagged Content List
  • Blog Post: Configuring SSIS DQS Domain Value Import

    In the previous blog article , I described how to use the free SSIS DQS Domain Value Import from OH22 data to automate importing values into a DQS Knowledge Base domain. In this article, I will go over the optional configuration to import invalid/error value types as well as to set synonyms. First...
  • Blog Post: Automating DQS Domain Value Import

    There are times when you may want to update a DQS Knowledge Base through an automated process. For example, you add new products in your ERP system and you would like to make sure the new product names are added to DQS Knowledge Base automatically. A free codeplex project, SSIS DQS Domain Value Import...
  • Blog Post: Handling error in SSIS DQS Domain Value Import

    In the previous blog article , I described how to use SSIS DQS Domain Value Import . An error may occur during the execution of the project due to problems with the data. There are several available configuration options to deal with the error, related to: Flow Execution Status Logging Knowledge...
  • Blog Post: Cleansing Customer Data Using Data Quality Services (DQS)

    SQL Server 2012 Data Quality Services (DQS) enables you to cleanse data using your own Knowledge Base. In this blog article, I am going to show how to create a simple Knowledge Base which you can use to cleanse your customer data. The steps for using DQS to cleanse data is as follows: A. Create...
  • Blog Post: DQS on the Twelve Days of SQL Server 2012

    Call to Action: When you’re done reading this article and checking out the resources it references, please take a moment to comment and let the DQS team know what additional resources you would like provided. If there’s a topic you would like covered in a blog post or webcast or demo, we...
  • Blog Post: Using the SSIS DQS Cleansing Component

    As part of our DQS CTP3 offering, we are releasing a new DQS SSIS component. This component incorporates the DQS cleansing functionality into an SSIS data flow. When should I use the SSIS DQS Cleansing Component? The DQS Cleansing component can add value when: 1. Cleansing should be performed...
Page 1 of 1 (6 items)