Data Services Designer - Passing Parameter/Variables

[Former Member]

Hi everyone!

I am trying to use in my project a parameter/variable to controll the date that my job will process.

For example, if my job executes daily, I want to automatically set the parameter/variable as sysdate. The query within my job will use this date to filter the datas.

How can I do that? I can do that by using parameter or variable?

How is the process to pass this variable (job -> workflow -> dataflow)?

Thanks a lot!!

[paul_kessler]

Create global variable $system_date in your job.

Place a script in front of your dataflow with this statement: $system_date = sysdate();

Use $system_date to filter the data

[Former Member]

Yes, it worked.

adding one more information, I used the script component to manage the data.