locked
Changing Values of Variable in SSIS RRS feed

  • Question

  • Hello friends, please what can I do to change the initial values of a variable when a SQL server agent job is run. For example I am running the job from year 2001 to 2010. I have created variables called var_start_year and var_end_year that have their values defaulted to 2001 and 2010 and I would like to know how to change the values before the job is run from the server

    Thanks
    Tuesday, February 22, 2011 10:02 PM

Answers