I've loaded in some data from an external source, it comes in as varchar when I do do a table update it a column with a type variant. I get Expression_type does not match column data type, expecting VARIANT but got VARCHAR(xxx) for Column yyyyyyy
How does one normally deal with type conversion during transform?
1 Community Answers
Ian Funnell —
Normally you would use a Convert Type component for simple datatype changes.
For more complex conversions (where you need to use SQL functions) you would use a Calculator component.