Blog Post

SQL Server Integration Services (SSIS) Blog

3 MIN READ

Using the SSIS DQS Cleansing Component

Copper Contributor

Mar 25, 2019

First published on MSDN on Jul 18, 2011 As part of our DQS CTP3 offering, we are releasing a new DQS SSIS component. This component incorporates the DQS cleans...

Updated Mar 25, 2019

Version 2.0

cleansing

ctp3

data quality

data quality services

denali

dqs

dqs cleansing

dqs cleansing component

dqs ssis

sql server

SSIS-Team

Copper Contributor

Joined March 25, 2019

View Profile

SQL Server Integration Services (SSIS) Blog

Follow this blog board to get notified when there's new activity

BekBrito

Copper Contributor

Sep 11, 2020

Hi!!!

I'm trying to use a DQ Component in SSIS but appear an error:

[Limpieza de DQS [99]] Error: System.Runtime.InteropServices.COMException (0xC0010009): Exception from HRESULT: 0xC0010009
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSOutputColumnCollection100.get_Item(Object Index)
at Microsoft.Ssdqs.Component.DataCorrection.Logic.DataCorrectionComponent.ValidateRecordLevelOutputColumns(IDTSOutput100 output, List`1 unvalidatedOutputColumns)
at Microsoft.Ssdqs.Component.DataCorrection.Logic.DataCorrectionComponent.ValidateComponentColumns()
at Microsoft.Ssdqs.Component.DataCorrection.Logic.DataCorrectionComponent.Validate()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate(IDTSManagedComponentWrapper100 wrapper)