Hi All,
I have a source table SRCTBL and destination is a dimension table that i am trying to apply the SCD1 changes. Both the table have the exact same columns and the same data types, but in the SCD Wizard when i tried to select the columns i am getting the following error message
Cannot map columns of different types.
Column 'CountyID' is of type 'System.Double' and column 'CountyID' is of type 'System.String'.
Column 'CourtID' is of type 'System.Double' and column 'CourtID' is of type 'System.Int32'.
I have checked multiple times and they are the same data types. Please need help.
Thanks