Hi , I have a situation where i have to use two execute sql tasks which yeilds the result and stored in an result set varibale rsProgress. can i use the same result set variable in two for each loop containers. Example: EST 1 contains query : select eid, ename from emp where eid=2 the result of this stored in user::rsprogress variable. EST2 contains query: select eid, ename,designation from emp its result can also ne stored in the same user variable user:rsprogress. later i want to use this variable user::rsprogress to be used in for each loop containers. is this possible.

You can reuse a variable, but the second task will overwrite the result of the first task.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter