DTS Programming

ErrorRows Property

The ErrorRows property specifies the number of error rows encountered for the current rowset by a transformation in a Transform Data task, Data Driven Query task, or Parallel Data Pump task.

Applies To

DTSTransformPhaseInfo Object

Syntax

object.ErrorRows

Part	Description
object	Expression that evaluates to a DTSTransformPhaseInfo object

Data Type

Variant/vt_decimal

Modifiable

Read-only

Prototype (C/C++)

HRESULT get_ErrorRows(VARIANT *pRetVal);

Remarks

The DTSTransformPhaseInfo object is referenced within a Microsoft® ActiveX® Script transformation or custom transformation.

Some scripting languages, for example Microsoft Visual Basic® Scripting Edition (VBScript), do not support the vt_decimal data type of the ErrorRows property. In VBScript, you should convert ErrorRows to Long before using it. For example, use the following code to compare ErrorRows to a global variable in VBScript:

If DTSGlobalVariables("GV1") > CLng(DTSTransformPhaseInfo.ErrorRows) Then ...

ErrorRows includes the current row if in the OnTransformFailure or OnInsertFailure phases.