DTS Programming
DTSTransformFlags
The DTSTransformFlags constants specify the flags controlling transformation. They are used to set the TransformFlags property of the Transformation object. These values are used during schema validation, which occurs before any rows are transformed.
| Constant | Value | Description |
|---|---|---|
| DTSTransformFlag_AllowDemotion | 1 | Allows the transfer to proceed even if there are potential overflows. Overflows that actually occur during transformation cause the row to be exceptioned. This value can be specified when the source values are all (or mostly) within the range of the destination column. |
| DTSTransformFlag_AllowLosslessConversion | 512 (x0200) | Allows all conversions for which a lossless conversion is possible (for example, Promotion, non-NULLable -> NULLable, unsigned -> signed with field size increase). |
| DTSTransformFlag_AllowNullChange | 16 (x0010) | Allows the transfer to proceed even if the source column allows NULL values and the destination column does not. Any row actually containing NULL is exceptioned, however. |
| DTSTransformFlag_AllowNumericTruncation | 8 | Allows the transfer to proceed even when numeric truncation is possible, such as when the source is a floating-point or numeric/decimal type and the destination is an integral type. Loss of significance occurs without error, but integer overflow still causes an error. |
| DTSTransformFlag_AllowPromotion | 2 | Allows the transfer to proceed when there is promotion in the data range when moving from the source to the destination types, such as I2->I4 or I4->float/double. |
| DTSTransformFlag_AllowSignChange | 32 (x0020) | Allows the transfer to proceed even in the event that the source and destination have a signed versus unsigned mismatch. As with DTSTransformFlag_AllowDemotion, errors may occur during a transform. |
| DTSTransformFlag_AllowStringTruncation | 4 | Allows column (w)char or byte data to be truncated silently (for example, when moving data from a char(60) to a char(40) column). |
| DTSTransformFlag_Default | 63 (x003F) | Includes the default flag combination of DTSTransformFlag_AllowDemotion, DTSTransformFlag_AllowNullChange, DTSTransformFlag_AllowNumericTruncation, DTSTransformFlag_AllowPromotion, DTSTransformFlag_AllowSignChange and DTSTransformFlag_AllowStringTruncation. |
| DTSTransformFlag_ForceConvert | 128 (x0080) | Allows the conversion to proceed at all times, even when the source and destination types are fundamentally different. Does a bitwise copy when no other conversion is appropriate. |
| DTSTransformFlag_PreserveDestRows | 256 (x0100) | Causes the data pump to not clear the destination row storage at the end of row processing. This allows the destination row values to be reused by the next transformation. |
| DTSTransformFlag_RequireExactType | 64 (x0040) | Requires that the data type of the destination column be exactly the same as the data type of the source column (including length or precision and scale, fixed versus variable length, sign, and nullability). |
| DTSTransformFlag_Strict | 0 | Specifies no flags; the conversion must be between exact types, although conversions between string and nonstring datatypes is allowed and may cause errors. This value may be overridden by DTSTransformFlag_RequireExactType, which is even stricter. |