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

Joel Manhede 0

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

Erland Sommarskog 111.1K Reputation points

2024-08-14T19:46:54.4166667+00:00

Instructed by whom or what? It could help if you could give a background of what you are actually doing. You have tagged your question SQL Server, but I see no direct relation to SQL Server. But maybe you are working with an SSIS package? (There is a separate tag SQL Server Integration Services.)
Jeremy Rutherford 0 Reputation points

2024-10-02T16:34:46.6766667+00:00

As Joel hasn't added any additional context, this is from following the SSIS tutorial here. https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16

1 answer

ZoeHui-MSFT 36,511 Reputation points

2024-08-15T06:48:28.89+00:00

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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

1 answer

Your answer