SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Winzip in scheduled DTS Package
 New Topic  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:\filename.zip 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\fcfiles.zip 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\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.

Any ideas?
Go to Top of Page

Almighty SQL Goddess

38113 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
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000