June 4, 2008 at 8:46 am
Just wondering how I can view the value of a package level variable when I run my package.
June 4, 2008 at 9:24 am
If you're talking about SSIS (sounds like it), you can set a watch on the variable in the dev studio.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 4, 2008 at 9:27 am
Yes I am talking SSIS -- could you walk me through how you would set a watch on the variable?
Thanks
June 4, 2008 at 9:58 am
June 4, 2008 at 12:21 pm
Still having some challenges folks -- maybe it would be better to explain what I am trying to accomplish.
I am trying to capture the value from an output parameter from a S.P. I am firing. I want to put it into a variable so I can use for the rest of my package specifically to supply another S.P. an input parameter value.
Please explain the mechanics of doing this.
Thanks,
June 4, 2008 at 12:39 pm
Ah, that's different!
In the "Execute SQL" object, it has a parameters tab. Set up a variable to store the output, assign it to the output parameter, and make sure the "direction" is output. That should do it.
I have to admit, however, that I've had problems with that function. I generally end up having the proc select the output instead of using an output parameter, set up the SQL Task object with a 1-row recordset, and assign the value of that to a variable.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply