Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
"DQS Cleansing failed the pre-execute phase" error when you run the DQS Cleansing transformation in SQL Server 2012
Article ID: 2715968 - View products that this article applies to.
Consider the following scenario:
DQS Cleansing failed the pre-execute phase and returned error code 0x80070057.
System.ArgumentException: Value does not fall within the expected range.
at Microsoft.SqlServer.Dts.pipeline.Wrapper.IDTSBufferManager100.FindColumnByLineageID(Int32 hBufferType, Int32 nLineageID)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)
This problem occurs because a destination is not set for the error output that is generated for rows that do not meet the DQS domain criteria and rules.
To resolve this issue, use one of the following methods.
Method 1If you do not want to redirect error rows, follow these steps to resolve the issue:
Method 2If you have to redirect your error rows then you must make sure that you have a destination location for the errors to be redirected to.