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

Christopher Jack 1,611 Reputation points
2021-06-24T14:36:21.303+00:00

Hi,

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

109073-image.png

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,460 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,296 Reputation points
    2021-06-25T02:31:21.68+00:00

    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.

    109166-62511.jpg

    109195-62522.png

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

    insert-transact-sql

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

    Zoe

    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