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

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.

