Hi all

I am trying to capture sysdate in a variable and then use this variable further in the package.

I have one execute sql task which is connected further to data flow task.

In execute sql task:

Insert into logging (sysdate)

Now after that in data flow task, i am using a oledb source which extract data from oracle.

select * from table1 where timestamp between max(tmstp) and sysdate.

I dont want sysdate in the above query as it changes every second. I want to get the same sysdate that was used in execute sql task fro logging purpose. Can we store that value in a variable and if so, can we use it the above query.

Thanks

Harjinder

I haven't tinkered with SSIS in a wee while and don't have a copy to hand but I can point you in the right direction to get you started.

Under the SSIS menu there is an option titled Variable

You'll need to create a new variable and set the scope to package level or global level (whichever you feel is most appropriate).

Then have a google around for ways to set and use SSIS variables.

HTH