Oct 12, 2011. You might want to consider some free command line unzip utilities, if you are not using one of the proprietary winzip compression. To close explorer sessions created by winzip @explorerBeforeWinzip = `tasklist /fi 'imagename eq explorer.exe'`; print 'extract zip files n'; `c: Progra~2 Winzip WINZIP32.
Sure J# Method: Pros: Free from Microsoft, Support *.Zip format Cons: Requires Coding, Requires Installation of J# Runtime on each machine where you execute the package, Supports basic options for compression. Pros: Native to.net Framework 2.0 and higher so no need for any seperate installation Cons: Doesn't support ZIP format. It only supports *.gz (GZip) format, Requires coding Using Winzip or PKZip Pros: Flexible options from commandline, Faster and Higher compression Cons: Have to purchase license and install on each server where you want to execute ssis package. No clean UI to generate command line and its not part of native SSIS either so you may have to do R&D to find commandline options and test your self.
Sure J# Method: Pros: Free from Microsoft, Support *.Zip format Cons: Requires Coding, Requires Installation of J# Runtime on each machine where you execute the package, Supports basic options for compression. Pros: Native to.net Framework 2.0 and higher so no need for any seperate installation Cons: Doesn't support ZIP format. It only supports *.gz (GZip) format, Requires coding Using Winzip or PKZip Pros: Flexible options from commandline, Faster and Higher compression Cons: Have to purchase license and install on each server where you want to execute ssis package. No clean UI to generate command line and its not part of native SSIS either so you may have to do R&D to find commandline options and test your self.
Dyson Serial Number Location Dc41 more. Using 3rd Party component (e.g. Task Factory from Pragmatic Works) Pros: No scripting needed and very easy to use, Faster and Higher compression ratio, provides most of advanced options on Main UI (e.g. Password Protected Zip, Compress whole folder. Zip Format Type etc.) Cons: You have to purchase license to use the component. I hope this helps!!! excellent - just what i need! Fannie Mae Homepath Program Guidelines.
I don't like the Execute Process Task because it requires winzip or an other tool on your production server and you're never really sure about ending the process successfully. I prefer the Script Task solution or third party component, but that always requires some installation work. Most of my clients prefer a Microsoft DLL above a third party/open source dll: I'm calling WinZIP64.exe from process task.It's running fine from Visual Studio and creating ZIP file. But, when I'm running from SQL job; my job is continuously running without making ZIP, also, its not showing error.I'm not getting how to solve this problem? Is this a problem of WinZIP64 exe?
Note: It was working fine previously through job but suddenly got stopped.Any clue how to make this work??
We are testing download an unzip of multiple files. Commands very similar to the ones shows are executed from a batch file (called from SSIS) C: Progra~1 WinZip WINZIP32.EXE -min -e -o -j C: TEMP ZipTest x1.zip C: TEMP ZipTest Z1 C: Progra~1 WinZip WINZIP32.EXE -min -e -o -j C: TEMP ZipTest x2.zip C: TEMP ZipTest Z2 C: Progra~1 WinZip WINZIP32.EXE -min -e -o -j C: TEMP ZipTest x3.zip C: TEMP ZipTest Z3 C: Progra~1 WinZip WINZIP32.EXE -min -e -o -j C: TEMP ZipTest x4.zip C: TEMP ZipTest Z4 Unfortunately, after it is done unzipping, four Explorer windows opens up (one for each archive). While it is easy to close these windows when it runs on my desktop, I cannot close any windows down that open up under the SSIS account. How do I prevent these windows from opening up?