TITLE: Microsoft Visual Studio ------------------------------ Cannot map the input column, 'CurrencyDate', to the lookup column, 'FullDateAlternateKey', because the data types do not match. ------------------------------ BUTTONS: OK -------------------

Question

i have changed the data types to DT_DBDATE as instructed but when trying to map the fields, it keeps saying I cannot map the currencyDate to the lookup column, FulldatealternateKey, because datatypes do not match

Answer 1

Go to connection manager as shown in step to

https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-2-adding-and-configuring-a-flat-file-connection-manager?view=sql-server-ver16

and change the data type of the currencyID and CurrencyDate

In the list, select the CurrencyID column and in the property pane, change the Data Type of column CurrencyID from string [DT_STR] to Unicode string [DT_WSTR].

In the property pane, change the data type of column CurrencyDate from date [DT_DATE] to database date [DT_DBDATE].

Hope this will solve the above problem

Answer 2

Hi @Joel Manhede,

What is the data type for 'CurrencyDate' and 'FulldatealternateKey'?

Please make sure they are match.

In addition, you may use data conversion to convert the data type in SSIS to make them match.

If this does not work, you may share some images of your package and check the column data.

Regards，

Zoe Hui

---

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