Anyone has a work around for using a source field with data tye navarchar(max) with SCD transformation. I tried Casting the field as navarchar(200), but still i recieve the same error as below.
Error at DimOpportunity [Slowly Changing Dimension ]: The input column "input column "description" (6912)" cannot be mapped to external column "external column "description" (6689)" 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.
View Complete Post