December 6, 2010 at 7:34 am
Hello gent
The problem is like this, on an "Execute SQL Task" editor's "Parameter Mapping" tab, if I click button "ädd", nothing pops up for adding new parameters (in this speicifc task, I am in need of a User::FileLocation parameter to be an inserted value into a table).
And if I fall back to the "properties" page of this task and in the dropdown list of "ExecValueVariable", I can still select "User:FileLocation" but when this pacakge is executed, the following error message shows:
"Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property."
Can anyone shed some lights on this issue? The sql server instance (2005 enterprise) is recently pached with SP3. I am speculating this is a problem from visual studio.
Thanks in advance!
Bazinga!
December 6, 2010 at 8:50 am
Problem solved.
The cause is that my integration development studio is on edition RTM while the sql server instance on SP3.
After patching the integration service with SP3, the "parameter mapping" tabs starts to work fine.
Bazinga!
December 6, 2010 at 8:54 am
So satisfying when you solve your own problems & no one else has a clue 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
December 6, 2010 at 8:59 am
Hopefully my solution can help people that would have the same issue and start searching on this site or google.
Bazinga!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply