I had this same exact problem in DTS, but found a much, much simpler solution: just make sure you use the "-yb" parameter in your WZUNZIP command line call.
My specific usage was:
-yb -o c:\filename.zip c:\DirectoryToUnzipTo The parameter listings required are all detailed in the WZUNZIP help files.
The DTS package is then saved as Structured Storage File and ran in a job using the dtsrun command line program.
I didn't see it mentioned earlier, but is your SQL server on a different machine than where you develope? If so, the DTS package will execute locally on your machine when run from the editor. Maybe there is a difference between the Winzip install on your machine and the server.
Would someone tell me what I need in order to ZIP a file within a DTS package?
I have the following:
Description: zip the xls Win32 process: C:\Program Files\WinZip\WINZIP32.EXE Parameters: c:\temp\claims.xls c:\temp\claims.zip Return Code: 0 Timeout: 0
When I execute just this step, I get the WinZip pop-up that states:
Multiple files were dropped, and one or more is an archive. Add files to archive?
I'm not sure what to answer here, nor how to go about doing it. I have found quite a few sites that have the -min -a etc. that should prefix the filenames but those give me various errors.
Winzip in scheduled DTS Package
Posted - 03/09/2004 : 23:35:22
