January 27, 2010 at 7:39 am
I have a package level variable that I can see inside my dataflow as well as an execute SQL task. But I added a sequence container and placed my dataflow inside it as well as added "a new" ExecuteSQL task inside the container as well. I still can see my user variables (Package Variable) inside my DataFlow but I can't see them in the parameters tab of the ExecuteSQL task that I added into the Sequence Container. Any ideas how to overcome this?
January 27, 2010 at 5:32 pm
That is strange. All package level variables should be visible everywhere. Don't know what you've tried up to this point but I'm guessing there may be some corruption. If you add a new package variable does it show? What is the scope of user variables that do show up?
I would consider a sanity check and create a new package and put the same components in it to check if the variable shows up. If so then you're best move is to rebuild in a new package or try rebuilding the piece that is not working. Be sure to post the outcome, I'm curious. gl
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply