TABLE 1: DTSTransformStatus Values
Constant Value Description
DTSTransformStat_AbortPump 16384 OR'd with prior bits to terminate processing any further rows and return DTSTransformExec_AbortPump 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 8194Terminate further processing of this row due to error and call the error sink, but do not write to exception file.
DTSTransformStat_ExceptionRow 8448Terminate further processing of this row as an exception, call the error sink, and write this row to exception file.
DTSTransformStat_Info 4096 Success with additional information, which the application may 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 4097Write row if destination specified; also call ErrorSink with information.
DTSTransformStat_SkipFetch 4 Do not fetch the next row; re-execute 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 4098Terminate further processing of this row, and call ErrorSink with information
DTSTransformStat_UpdateQuery 32 Executes the UPDATE statement passed to the SetRowsetAndQueries property on the destination, with values from the currently transformed destination row.
DTSTransformStat_UserQuery 128 Executes the user query statement passed to SetRowsetAndQueries on the destination, with values from the currently transformed destination row.