The Data Conversion transform allows change of data type of a column to another data type.
The Data Conversion transform requires 1 input transform that has at least 1 column.
For example, data coming from a CSV file may be recognized as a String but it is known to be a DateTime (e.g. the ModifiedDate column).
In the Data Conversion configuration dialog, you must configure the following settings:
- Select the columns you want to be included on the output.
When using CSV files as data source, numeric data types are auto-detected as Double. All others data types are auto-detected as String.
- For each selected column, use the dropdown list to select a new data type.
The format required for converting into Date/Time depends on the structure of the input string
- "2014-01-21T20:28:21.703" would need to be yyyy-MM-ddTHH:mm:ss.fff
- See MSDN - Custom Date and Time Format Strings for more information
The figure below illustrates the output from the Data Conversion transform.