1

Closed

RecordsOnTargetNotFoundOnSource = Update Date To - has no effect

description

I've noticed that setting/leaving the Configuration property RecordsOnTargetNotFoundOnSource = "Update Date To" does not seem to have any effect on the generated SQL?

I was expecting this to generate something like the following:

WHEN NOT MATCHED BY SOURCE
THEN UPDATE
SET [target].[DateTo] = GETDATE()
;

Am I missing something?
Closed Jun 2, 2013 at 10:51 AM by knyazs
Fixed in version 3.0

comments

knyazs wrote May 9, 2013 at 4:51 AM

Hi MikeHoney!

This was not problem in previous versions. I will definitely check this and provide the update if needed.

Thanks,
Miljan