question

ChristopherJack-1763 avatar image
0 Votes"
ChristopherJack-1763 asked ZoeHui-MSFT edited

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

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
image.png (72 B)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @ChristopherJack-1763,

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



62522.png (26.4 KiB)
62511.jpg (37.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.