Unable in SSIS to join a date column to a date column on a table

Christopher Jack 1,611 Reputation points


I am unable in SSIS to join a date column to a date column on a table.

To being with I am casting

CAST(dateadd(S, [ExWorksDate], '1970-01-01') as date) as [ExWorksDate]

then in the lookup I am trying to join it to the full date column which is a date time column.

How ever when I drag it over it comes up with


There is not really any values in the ExWorksDate so it is trying to match nulls against date.. could that be an issue?

Also other ones have nulls in which seem to connect fine ?

Any help Appreciated.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,469 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,701 Reputation points

    Hi @Christopher Jack ,

    The image about the issue is broken that we couldn't see the error message.

    If possible could you help provide the simple data of the two table?

    I just did a simple test as shown below.



    Also if you may directly use insert into with t-sql to add all values of a table into another table.


    If I misunderstand your needs, please incorrect me and give us more details.


    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

    0 comments No comments