A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [data-quality-services]

Data Quality Services is a Microsoft SQL Server-related technology providing correction, enrichment, standardization, and de-duplication of data.

Filter by
Sorted by
Tagged with
0
votes
0answers
32 views

Is there anyway to automate DQS knowledge base discovery process, using SSIS or any SQL job?

We are implementing a data warehouse for our client and part of it requires the development of metadata repository. Now, that repository, other than metadata information, would also contain domain ...
5
votes
2answers
103 views

How can we trim bad data and output clean trimmed data using DQS or MDS?

Until now, we have used stored procedures for data massaging and cleansing but we have now decided to move to using Data Quality Services (DQS) and Master Data Management (MDS) in our data warehouse ...
3
votes
1answer
1k views

How to remove Data Quality Services completely?

When I setup one of our SQLServer 2012 instances a while back, I didn't realize that I have checked "Data Quality Services" feature. Looking at my installation notes, I find that I didn't end up ...
1
vote
0answers
7 views

SSDT no avaible input column error

i am learning SSDT from this link https://msdn.microsoft.com/en-us/library/jj819740(v=sql.120).aspx on point 8 i stuck before that i install DQS successfully and also connected to Data Quality ...
2
votes
0answers
26 views

How to retrieve the distinct domains of a compound domain from DQS using SSIS?

MS Data Quality Services (DQS) has a concept of Compound Domains, which lets you turn say "'99 Chevy Maliboo" into {year:1999, brand:Chevrolet, model:Malibu} SSIS has a "DQS Cleansing" component. It ...
0
votes
1answer
440 views

MS SQL Server 2012 Data Quality Services (DQS) installation failure

I tried to install MS SQL Server 2012 DQS using DQSInstaller.exe, but installation failed. In the console output started by the install tool (DQSInstaller.exe) I found this line: Password validation ...