Modify Column Type

The Modify Column Type transformation command allows you to change the data type of an input column. For example, you can change to number a field in the input source that has numeric values but but is stored as text or change a datetime input column to a date data type.

Configuration

After you add a Modify Column Type ETL command to the Data Flow designer and connect an input to it, you need to select:

• The column to set its data type.

• The new data type for the column.

• The name of the new column.

The id_number in the example above was saved as text in the csv data source, we used a Modify Column Type ETL command to change it to a number and renamed the column to MemberId.