hi all,i am trying to assign a value to a ssis variable though the resultset of execute sql task.now i have mapped the varialbe properly.i have set the resultset as single row.i am doing everything step by step as the book saysbut believe me i am unable to assign a value to variable.the task executes properly it says success but variable value just doesnot change.no matter what ido.please throw some ideas or do i have to take any extract precautions.thanks in advance.
See this http://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/ which should let you achieve what you want.
