question

bk-4602 avatar image
0 Votes"
bk-4602 asked ZoeHui-MSFT answered

SCD1 Column mismatch error

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

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @bk-4602,

You may add a Data Conversion to convert the data type and then pass it to SCD.

Details of data type in SSIS you may refer below.

integration-services-data-types

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.