'Set values' tab in Job properties step RRS feed

  • Question

  • Hello,


    I'd like to set a variable to a value in the 'Job Step Properties' in creating an SSIS package as a job. I've tried different syntax and cannot get it to accept anything.


    Property Path                                                                    Value

    \waiver_export.Variables[::fellowship_year_id]                         7



    My variable is fellowhip_year_id, the package is waiver_export. How do I assign a value to this variable at runtime?





    Tuesday, August 26, 2008 7:24 PM

All replies

  • Try the following int the Property path

    Code Snippet




    Tuesday, August 26, 2008 9:38 PM
  • Doesn't work.


    Could not set \waiver_export.Variables[fellowship_year_id].Value value to 7.  Started:  9:36:27 AM  Finished: 9:36:28 AM  Elapsed:  0.828 seconds.  The package execution failed.  The step failed.



    Any other ideas?





    Wednesday, August 27, 2008 2:39 PM
  • This worked:




    Wednesday, August 27, 2008 2:46 PM
  • Try


    Code Snippet





    This assumes that the variable is declared with package scope.
    Wednesday, August 27, 2008 2:47 PM