CurrentSourceRow Property

DTS Programming

DTS Programming

CurrentSourceRow Property

The CurrentSourceRow property specifies the current source row being processed by a Transform Data task, Data Driven Query task, or Parallel Data Pump task.

Applies To
DTSTransformPhaseInfo Object
Syntax

object.CurrentSourceRow

Part Description
object Expression that evaluates to a DTSTransformPhaseInfo object

Data Type

Variant/vt_decimal

Modifiable

Read-only

Prototype (C/C++)

HRESULT get_CurrentSourceRow(VARIANT *pRetVal);

Remarks

The DTSTransformPhaseInfo object is referenced within a transformation script or custom transformation.

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

DTSGlobalVariables("GV1") = CLng(DTSTransformPhaseInfo.CurrentSourceRow)

See Also

Data Driven Query Task

DestinationRowsComplete Property

DTSTransformScriptProperties2 Object

ErrorRows Property

ParallelDataPumpTask Object

Transform Data Task