TABLE 1: DTSTransformStatus Values
Constant Value Description
DTSTransformStat_AbortPump 16384 OR'd with prior bits to terminate processing any further rows and to return DTSTransform- Exec_Abort Pump from IDTSDataPump::Execute.
DTSTransformStat_DeleteQuery 64 Executes the DELETE statement passed to the SetRowsetAndQueries property on the destination, with values from the currently transformed destination row.
DTSTransformStat_Error 8192 Bit-OR'd into the following error returns.
DTSTransformStat_ErrorSkipRow 8194 Terminate further processing of this row because of an error and call the error sink, but do not write to the exception file.
DTSTransformStat_ExceptionRow 8448 Terminate further processing of this row as an exception, call the error sink, and write this row to the exception file.
DTSTransformStat_Info 4096 Success with additional information, which the application might want to 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 Executes the INSERT statement passed to the SetRowsetAndQueries property on the destination, with values from the currently transformed destination row.
DTSTransformStat_OK 1 Default conversions (if any) succeeded; write the row to destination if specified, without calling any error handlers.
DTSTransformStat_OKInfo 4097 Write row if destination specified; call the 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 non-error reasons.
DTSTransformStat_SkipRowInfo 4098 Terminate further processing of this row; call ErrorSink with information.
DTSTransformStat_UpdateQuery 32 Execute the UPDATE statement passed to the SetRowsetAndQueries property on the destination, with values from the currently transformed destination row.
DTSTransformStat_UserQuery128Execute the user query statement passed to SetRowsetAndQueries on the destination, with values from the currently transformed destination row.