Hi All,
I need to bring in incremental data from my azure sql source. Basically filter based on UpdateTime. So, i have created a log table as below: -

I have used a lookup activity to get the LastUpdateTime. I have to set the LastUpdateTime of these 6 tables to 6 variables. How can i loop and set these variable values? I can pivot and bring the LastUpdateTime in row. But then I have to use 6 setvariable tasks?
My source query is a single query which joins all these tables and get only the rows that have modified date greater than LastModifiedDate.
Once these variables are set, I will have to use these variables in sourcequery.
Thanks
Regards,
Nagesh CL



