September 28, 2010 at 7:12 am
I've got a zip file that changes names from month to month. I.E. MyZipFile_20100925.zip or MyZipFile_20101018.zip.
Inside my ForEach container is an Execute Process Task that I'm trying to activate PKUnzip with. When I run this from my desktop, it opens a command prompt window and sort of freezes rather than unzips the file. Like it's searching for the file.
The container populates @[User::ZipFileName] with Name and extension. @[User::FileDirectory] is a package wide variable that is set via an XML config file. Currently, that value is \\DevServer\MainShare\Folder1\Folder2\Folder3\.
Both Executable & Arguments are set up in the Expressions tab of the EPT Editor. Though I did have to fill in values in the Process Tab
Executable: \\DevServer\MainShare\Folder1\Folder2\Folder3\pkunzip.exe
Arguments: -e-o
Expressions -
Executable: @[User::FileDirectory] + "pkunzip.exe"
Arguments: " -e-o " + @[User::ZipFileName]
I've tried setting the Working Directory to \\DevServer\MainShare\Folder1\Folder2\Folder3\, but that hasn't changed anything.
I've tried this with the WinZip command line tool, but it got stuck when we tried to run it through the job due to other issues. So now I'm trying PKUnzip and not having much better luck. Does anyone have any suggestions?
September 28, 2010 at 7:57 am
Brandie I'm really surprised you have not gone with 7zip, after all the trouble you've been having, and the recommendations from other posters.
I used to use commandline pkzip when it was freeware, (version 2.5) which still supported large filenames and zips greater than two gig; as far as i know the newer versions are paid-ware, and the syntax may have changed.
the syntax i used was as follows:
--Create Zip File of the Backup
--pkzip -a "C:\MSSQL7\BACKUP\GMVB-Monday.zip" "C:\MSSQL7\BACKUP\GMVB-Monday.bak"
Lowell
September 28, 2010 at 8:22 am
Lowell (9/28/2010)
Brandie I'm really surprised you have not gone with 7zip, after all the trouble you've been having, and the recommendations from other posters.
Lowell, I work at a company that does not allow unauthorized software (I thought I mentioned that in the other thread). I have to jump through hoops to get stuff approved. That being the case, I'd rather work with the options I have. If I can't get them to work, then I'll ask about 7zip, but I can't just install it and I can't ask for it without making sure I can't get the other solutions to work.
Thanks for the syntax, but it won't work within an SSIS Execute Process Task. I've tried something similar and it kept bombing out if I had anything listed after the .exe file.
September 28, 2010 at 8:32 am
gotcha...your agency already had pkzip/pkunzip; I has assumed (you know the rule on THAT) that you bought that product as new.
Lowell
September 28, 2010 at 8:53 am
Ohhh. Now I'm annoyed. I thought I'd figured it out. Yet, for some reason, pkunzip.exe is opening up a Winzip window.
GRRRR.
September 28, 2010 at 11:46 am
Brandie Tarvin (9/28/2010)
Ohhh. Now I'm annoyed. I thought I'd figured it out. Yet, for some reason, pkunzip.exe is opening up a Winzip window.
Note to self. Always check the task for config file crossover before changing locations of things. DOH.
But I'm still getting an error:
Error: 0xC0029151 at Unzip File, Execute Process Task: In Executing "pkunzip.exe" " -e -o
\\DevServer\MainShare\Folder1\Folder2\Folder3\MyZipFile_20100701.zip" at "\\DevServer\MainShare\Folder1\Folder2\Folder3\", The process exit code was "11" while the expected was "0".
Executable: pkunzip.exe
Argument (Expression): " -e -o " + @[User::FileDirectory] + @[User::ZipFileName]
Working Directory (Expression): @[User::FileDirectory]
Any other thoughts?
September 28, 2010 at 12:13 pm
Nevermind. I'm using a horrendously old version of PKUnzip which won't handle long file names. Back to drawing board.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply