Share via

Struggling with SSIS lookup date key transformation

Susan Gatura 0 Reputation points
2024-03-21T12:09:24.4733333+00:00

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,479 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.
502 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Zahid Butt 556 Reputation points
    2024-03-21T14:36:29.1766667+00:00

    Hi,

    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.

    Regards,

  2. ZoeHui-MSFT 34,186 Reputation points
    2024-03-22T01:31:06.7566667+00:00

    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.

    Regards，

    Zoe Hui

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

    0 comments