how to use same variable between the control flow tasks in SSIS 2005?

I want to get the start time of data load and end time after data load and store it in a table which has mapping_id , mapping_name,start_time,end_time.

i use ActiveXScript task to get the start time before data load and store the mapping_id in a global variable,then data flow transformation occurs.

i want to use a global variable to store the mapping id ,so that i can update the end time after data load with that variable.how to do this?

is there any other way, i can get the start and end time of data load (other than the logging information)?

Using an execute SQL task you can do this. One before the data load, and one after.

In the first, you can use System:: StartTime. In the second you can use getdate().

In the first, you'd have to map the parameter, in the second you just use getdate() in the SQL.|||How do you get the mapping id? If you have the mapping id you could use a number of Execute SQL Task shapes in the control flow to update the start and end times at the relevant step.

Greg.

|||What is the mapping_id?