Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Casting when doing table update

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

Matillion Agent  

Ian Funnell —

Hi Jesse,

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.

Best regards,
Ian

Post Your Community Answer

To add an answer please login