Transformation Flags
Use this dialog box to customize data conversions between source and destination columns and enforce the stringency with which data type conversions are allowed. The transformation flags available through this dialog box correspond to a subset of the members of the DTSTransformFlags object class.
Options
Default transformation flags
Allow all possible data conversions. This is the least stringent data conversion setting. It corresponds to the DTSTransformFlag_Default constant.
Require exact match between source and destination
Enforce that data types match exactly in source and destination columns. If there is not an exact match, an error is generated. Use the Advanced tab of the Data Transformation Properties dialog box for error handling. This setting corresponds to the DTSTransformFlag_RequireExactType constant.
Custom transformation flags
Enable selection of the three transformation flag settings listed in the following options.
- Allow data type promotion
- Allow data type promotion from 16-bit integer to 32-bit integer numbers. This setting corresponds to the DTSTransformFlag_AllowPromotion constant.
- Allow data type demotion
- Allow data type demotion from 32-bit integer to 16-bit integer numbers. This setting corresponds to the DTSTransformFlag_AllowDemotion constant.
- Allow NULL conversion
- Allow data conversions from columns that allow NULL values to columns that do not. This setting corresponds to the DTSTransformFlag_AllowNullChange constant.