Transformation Flags

DTS Designer

DTS Designer Help

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.

See Also

TransformFlags Property