DTS Programming
DTSTransformStatus
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. |