Struggling with SSIS lookup date key transformation

Susan Gatura 0 Reputation points

How do i fix the below error, i have confirmed a million times that the data type is the same.

User's image

The date formats are different though. Could that be the problem

User's image

User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
489 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Zahid Butt 556 Reputation points


    Date formats should be same.

    In this case CurrencyDate seems to be with Datetime but other one is simple date so it will create issue.


  2. ZoeHui-MSFT 32,411 Reputation points

    Hi @Susan Gatura

    It is clear that the two columns have different datatype and could not match.

    You may add data conversation in the SSIS package to make them match.


    Zoe Hui

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

    0 comments No comments