SSIS : Look up transformation Parameter

Question

Hello Team - How do I replace the below parameter with the logic?

below is the current logic

where [value_timestamp] >= dateadd(dd,-1, service_date)

I want to replace the where clause for valuetimestamp like below :

where [value_timestamp] between dateadd(hh,-24, service_date) and service_date

Does this work ?
where [value_timestamp] between dateadd(hh,-24, ?) and ? -- But do i need to create another parameter for this ( parameter 2 for teh SERVICE_DATE ?

Thank you

Answer 1

Hi @kkran .

It should be work with where [value_timestamp] between dateadd(hh,-24, ?) and ?.

Below is my simple test that I have not created another parameter and the task works.

An example you may also take a reference: partial-cache-lookup-with-a-date-range

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