got the param passing to package variable working.  Within Execute SQL Task, I had been trying to use parameter mapping to output a parameter rather than the result set functionality on...

any other thoughts/suggestions on this?

Thanks janette

Hi Jamie,

  setting up the sql task parameter is fine. just have a simple query declare @LRun datetime

set @LRun = (select * from JobStore)

Param mapping:var name - LRun, direction - I,...

me again... think i have manged to get the var scoping working (had a look at some of your associated articles) However, I have just noticed that the correct value...

Hi Jamie,

      Yes I am using parent package configuration. setting the configuration from the child and refernecing the var in the parent package. one other question.  does the variable in...