The input column "%1!s!" cannot be mapped to external column "%2!s!" because they have different data types. The Slowly Changing ...

The input column "%1!s!" cannot be mapped to external column "%2!s!" because they have different data types. The Slowly Changing Dimension transform does not allow mapping between column of different types except for DT_STR and DT_WSTR.