Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

cleansing

10 Topics

New Online Course for General Training on The Usage of DQS
First published on MSDN on Jan 25, 2017 Hello everyone,We've recently published a new online course via edX to provide general training on the usage of DQS.
Sandy Winarko
Jul 02, 2021 Place SQL Server Integration Services (SSIS) Blog
1.9KViews
1like
1Comment
Automating DQS Domain Value Import
First published on MSDN on Aug 05, 2013 There are times when you may want to update a DQS Knowledge Base through an automated process.
Welly Lee
Feb 17, 2021 Place SQL Server Integration Services (SSIS) Blog
1.4KViews
1like
1Comment
Using the SSIS DQS Cleansing Component
First published on MSDN on Jul 18, 2011 As part of our DQS CTP3 offering, we are releasing a new DQS SSIS component.
SSIS-Team
Sep 11, 2020 Place SQL Server Integration Services (SSIS) Blog
1.9KViews
0likes
1Comment
Languages supported by DQS for Cleansing and Matching
First published on MSDN on Mar 14, 2013 Data Quality Services (DQS) internally stores the domain values in a knowledge base in the Unicode format, and uses the trigram algorithm, which is language agnostic, to compare the domain values with your source data for the cleansing and matching operations.
SSIS-Team
Sep 11, 2020 Place SQL Server Integration Services (SSIS) Blog
1KViews
0likes
1Comment
Configuring SSIS DQS Domain Value Import
First published on MSDN on Aug 05, 2013 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.
Welly Lee
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
1.4KViews
0likes
0Comments
Handling error in SSIS DQS Domain Value Import
First published on MSDN on Aug 03, 2013 In the previous blog article, I described how to use SSIS DQS Domain Value Import.
Welly Lee
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
1.1KViews
0likes
0Comments
Cleansing Customer Data Using Data Quality Services (DQS)
First published on MSDN on Jun 14, 2013 SQL Server 2012 Data Quality Services (DQS) enables you to cleanse data using your own Knowledge Base.
Welly Lee
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
2.5KViews
1like
0Comments
Cleansing your Customer Data using Dun & Bradstreet DQS service
First published on MSDN on Jun 11, 2013 Starting today you can use SQL Server Data Quality Service (DQS) to cleanse data using Dun & Bradstreet (D&B) extensive business information data.
Welly Lee
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
1.6KViews
0likes
0Comments
DQS on the Twelve Days of SQL Server 2012
First published on MSDN on Apr 18, 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.
Matthew Roche
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
549Views
0likes
0Comments
How to add Reference Data Services in Data Quality Services (DQS)
First published on MSDN on Jul 20, 2011 SQL Server Data Quality Services (DQS) is a knowledge-driven data quality solution.
SSIS-Team
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
4.4KViews
0likes
0Comments