DTSTransformStatus

DTSTransformStatus

SQL Server 2000

The DTSTransformStatus constants return values (int or long) from the ActiveXScriptTask object transformation.

Constant Value Description
DTSTransformStat_AbortPump 16384
(x4000)
Processing is terminated with the current row and DTSTransformExec_AbortPump is returned from IDTSDataPump::Execute.
DTSTransformStat_DeleteQuery 64
(x0040)
The executed DELETE statement is passed to the SetRowsetAndQueries property on the destination, with values from the currently transformed destination row.
DTSTransformStat_DestDataNotSet 512
(x0200)
The current row is not written to the destination only if all transformations return this value. If present in the returned status of a transformation, it is removed before being passed to the next transformation through DTSTransformPhaseInfo.TransformStatus.
DTSTransformStat_Error 8192
(x2000)
Indicates the transformation encountered an error.
DTSTransformStat_ErrorSkipRow 8194
(x2002)
Terminate further processing of this row due to error and call the error sink, but do not write to exception file.
DTSTransformStat_ExceptionRow 8448
(x2100)
Terminate further processing of this row as an exception and call the error sink, and write this row to exception file.
DTSTransformStat_Info 4096
(x1000)
Success with additional information, which the application can process further by reading its pvTransformUserData value (if it shares that knowledge with the transform server) or through OLE DB error records.
DTSTransformStat_InsertQuery 16
(x0010)
Executes the INSERT statement passed to the SetRowsetAndQueries property on the destination, with values from the currently transformed destination row.
DTSTransformStat_NoMoreRows 32768
(x8000)
The current row is the last to be processed. The current row is processed as specified by other transformation status values. This value differs from DTSTransformStat_AbortPump in that no error is raised.
DTSTransformStat_OK 1 Default conversions (if any) succeeded. Write the row to destination if specified, without calling any error handlers.
DTSTransformStat_OKInfo 4097
(x1001)
Write row if destination specified; also call ErrorSink with information.
DTSTransformStat_SkipFetch 4 Do not fetch the next row; reexecute all transforms against the current source and destination rows.
DTSTransformStat_SkipInsert 8 Do not write the current row to the destination.
DTSTransformStat_SkipRow 2 Terminate further processing of this row, for nonerror reasons.
DTSTransformStat_SkipRowInfo 4098
(x1002)
Terminate further processing of this row, and call ErrorSink with information.
DTSTransformStat_UpdateQuery 32
(x0020)
Executes the UPDATE statement passed to the SetRowsetAndQueries property on the destination, with values from the currently transformed destination row.
DTSTransformStat_UserQuery 128
(x0080)
Executes the user query statement passed to SetRowsetAndQueries on the destination, with values from the currently transformed destination row.

See Also

IDTSDataPumpErrorSink

Show:
© 2016 Microsoft