July 7, 2010 at 12:24 pm
Hi SSIS experts,
I have a Execute SQL Task that outputs a parameter User::RecCount. On the PostEvent of the task, I could see that the RecCount value was updated to 100 (BTW, the initialized value was -1).
However, when I try to grab the RecCount from output Parameter in the next task, the RecCount was back to -1.
Why didn't it keep the value as soon as it exit out the "Execute SQL Task"? How could I keep it?
Sorry I don't know how to post images here. If you know the task, you know what I am talking about.
Thanks in advance for any help!
July 7, 2010 at 4:26 pm
Just to confirm, do you have only one variable User::RecCount or multiple variables with same name and different scope - one for Execute SQL Task and another for Package? If Yes then this is the reason.
July 7, 2010 at 6:00 pm
I just have one RecCount Variable and I had set it to be global to the package level and initialized to 0.
July 7, 2010 at 6:06 pm
Oh, no, i lied.
Just checked again, you were indeed right!
Can't believe that I made that mistake. I thought I checked.
Thanks!!!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy