Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Winzip in scheduled DTS Package
 Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Starting Member

2 Posts

Posted - 03/09/2004 :  23:35:22  Show Profile  Reply with Quote
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:\ c:\DirectoryToUnzipTo
The parameter listings required are all detailed in the WZUNZIP help files.
Go to Top of Page

Starting Member

3 Posts

Posted - 03/11/2004 :  14:04:29  Show Profile  Reply with Quote
This is directly from a DTS package that has a step to zip files in a folder. I'm using a registered version of Winzip's console.

Win32 Process: C:\Program Files\WinZip\WZZIP.EXE
Parameters: -rp c:\tms\fc\ c:\tms\fc\*.*

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.
Go to Top of Page

Starting Member

5 Posts

Posted - 08/20/2008 :  16:17:40  Show Profile  Send cmallain a Yahoo! Message  Reply with Quote
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\
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.

Any ideas?
Go to Top of Page

Almighty SQL Goddess

38200 Posts

Posted - 08/20/2008 :  16:20:02  Show Profile  Visit tkizer's Homepage  Reply with Quote
cmallain, start a new thread rather than hijacking one that is a few years old.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server

Subscribe to my blog
Go to Top of Page

Starting Member

5 Posts

Posted - 08/20/2008 :  16:29:38  Show Profile  Send cmallain a Yahoo! Message  Reply with Quote
Shouldn't I keep things in the same path though? Sorry, my other threads kept everything in the same path instead of a new one...
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000