can single reseultset varibale of Execute SQL Task hold multiple datasets in ssis
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.
May 29th, 2012 1:49am
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
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2012 2:25am