February 1, 2016 at 3:08 pm
Hi All,
Version: SSIS 2008 R2
I am trying to use an 'Execute Process Task' along with winzip to unzip a file. I have it working as long as I don't use unc paths. If I use a mapped (drive) path then the process works as expected.
This is my current expression (am using 2 variables 1 for the source file path and 2nd for the unzip to folder): "-e -o " + "\"" +@[User::Source]+"\"" + " " + "\"" + @[User::Folder] + "\""
in the expression builder it evaluates correctly:
-e -o "\\cfhp-fs1\cfhp-01 vol2\Information Systems\Documentation\filname.zip" "\\cfhp-fs1\cfhp-01 vol2\Information Systems\Documentation\FolderUnzip"
The problem is that when I actually run the process, this is the error I get:
[Execute Process Task] Error: In Executing "C:\Program Files\WinZip\WZUNZIP.exe" "-e -o"\\cfhp-fs1\cfhp-01 vol2\Information Systems\Documentation\filename.zip" "\\cfhp-fs1\cfhp-01 vol2\Information Systems\Documentation\FolderUnzip"" at "", The process exit code was "10" while the expected was "0".
It seems that when it actually runs it's putting in extra ' " ' I have tried for hours with different combinations of expressions, but to no avail. I have searched online too and have had no luck finding why this is happening.
Any assistance will be greatly appreciated.
Thanks
Michael
February 3, 2016 at 11:00 am
I have resolved this by passing the UNC via a script task.
Thanks
Michael
February 4, 2016 at 7:11 am
you're using an expression to pass to the Arguments property, is that correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2016 at 9:58 am
Perry Whittle (2/4/2016)
you're using an expression to pass to the Arguments property, is that correct?
Yes, that is correct - I am building the argument value in an expression.
Thanks
Michael
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply