I am still not able to make any progress.

The steps i am doing:

1st step:Execute Sql task--To get the max(date) mdate from table and assign the madate to user defined variable in resultset otopn of task.

2nd Step: Another Execute Sql task to delete the data from table based on passed parameter

3rd Step:Drag n drop a data flow task--it contains one oledb source

and one oledb destination.

Inside oledb source, i have defined oledb connection manager.

Data access mode is sql command and passing SP name e.g.

exec sp_name @UserDate = ?

@UserDate is actual input parameter passed to SP.

After this i am maaping parameter with User variable.

Once i click on preview i get the error messgae..no value given for one or more required parameter.

If i change the sql command like exec sp_name ? then also same error.

Can anyone help me to resolve this?