大网数据广告活动
数据库与应用安全

Error when you run the DQS Cleansing transformation

· 52CE 我爱测

This article provides two workarounds for the problem where an error is logged in the SSIS log on SQL Server.

This article helps you to work around the problem where an error is logged in the SSIS log on SQL Server.

Applies to:   SQL Server
Original KB number:   2715968

Symptoms

Consider the following scenario:

  • You use the Data Quality Services (DQS) Cleansing transformation in a SQL Server-Integrated Service (SSIS) Data Flow to cleanse your data in Microsoft SQL Server.
  • You set the "Configure error output" setting of the DQS Cleansing transformation to "Redirect row." However, you don't specify a location to save the error output.
  • You execute the SSIS package.

In this scenario, the following error message is logged in the SSIS log:

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.Ssdqs.Component.DataCorrection.Logic.DataCorrectionComponent.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

Cause

This problem occurs because a destination isn't set for the error output that is generated for rows that don't meet the DQS domain criteria and rules.

Resolution

To resolve this issue, use one of the following methods:

  • Method 1

    If you don't want to redirect error rows, follow these steps to resolve the issue:

    1. Open the DQS Component in the DQS Cleansing Transformation Editor.
    2. Select Fail Component in the Configure error output drop-down list at the bottom of the DQS Cleansing Transformation Editor.
  • Method 2

    If you have to redirect your error rows, you must make sure that you have a destination location for the errors to be redirected to.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/09/2025
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。