question

kkran-5951 avatar image
0 Votes"
kkran-5951 asked ZoeHui-MSFT commented

SSIS : Look up transformation Parameter

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)
127752-whatsapp-image-2021-08-30-at-64733-pm.jpeg



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

sql-server-generalsql-server-integration-services
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 commented

Hi @kkran-5951.

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.

127784-screenshot-2021-08-31-141514.jpg

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




· 3
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.

Hi @Zoehui-MSFT - I have added the logic and it is automatically asking for 3rd parameter. Please see below.

So, i think Parameter 1 and 2 will be service_date ?
127920-whatsapp-image-2021-08-31-at-11133-pm.jpeg


0 Votes 0 ·

Hi @Zoehui-MSFT choose service date as the third parameter value and have a try.

0 Votes 0 ·

Hi @kkran-5951.
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·