DTSTransformStatus constants return values (int or long) from ActiveXScriptTask object transformation.
| 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 | 8194 | Terminate further processing of this row due to error and call the error sink, but do not write to exception file. |
| DTSTransformStat_ExceptionRow | 8448 | Terminate further processing of this row as an exception and 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 | 4097 | 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 | Terminate 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. |