April 3, 2012 at 10:50 am
Hey everyone. Need some help.
I have an SSIS package (2005). Inside of the package, I have an Exec Process Task. This task is setup to call a .bat file that does a robocopy between two drives.
So in the Process Tab I have an executable value of C:\Scripts\CopyMe.bat
The Arguments are based upon an expresssion. The expression is setup as follows:
Field1 = Arguments. Actual Expression = " " + @[User::DatabaseName]
No other values or options are used and everything has been left as the default values.
When the task runs, everything get's copied as expected. However, the task is still throwing an error. The error I am getting is:
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
I have no idea what is going on and I don't seem to be able to find stuff on it. Was hoping that someone here would be able to give me some insight as to what is going on and why I am getting an error when it is coping correctly.
Thanks,
Fraggle
April 4, 2012 at 5:11 am
Does the error persist if you drop and recreate the task?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 3:24 pm
Actually, I figured it out. The error was more helpful than original thought.
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property
Hitting F4, I found the property (which isn't listed in the task), and found that it had a user::variable assigned to it. Apparently, it was causing the issues, because as soon as I removed it, the entire process started working just fine without errors getting thrown.
Just find it odd that I was getting the part about "unable to set the value of the variable" when I use the same variable in the expression I originally posted.
Thanks for the assistance.
Fraggle
April 4, 2012 at 3:30 pm
Glad you found the issue, and thanks for posting back!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply