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

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 WinZip in a DTS package
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cmallain
Starting Member

USA
5 Posts

Posted - 08/20/2008 :  16:31:44  Show Profile  Send cmallain a Yahoo! Message  Reply with Quote
I was told by Tara to start a new thread...even though my subject is the same as the old one...doesn't make much sense to me but here it is...again...


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?
Thanks!
Carol
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/20/2008 :  22:57:31  Show Profile  Reply with Quote
Should it be easier to do outside of dts?
Go to Top of Page

cmallain
Starting Member

USA
5 Posts

Posted - 08/21/2008 :  00:25:41  Show Profile  Send cmallain a Yahoo! Message  Reply with Quote
quote:
Originally posted by rmiao

Should it be easier to do outside of dts?



I'm not sure what you are asking? If you are asking why I just don't manually do this, the answer is that I have scheduled jobs that run each day that are to provide these zipped files. I don't have the time or resources to do such so I want to schedule a SS2k job to handle this.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/21/2008 :  23:08:58  Show Profile  Reply with Quote
Didn't say do it manually. You can use cmdexec process to unzip file in sql job, much easier to do.
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.22 seconds. Powered By: Snitz Forums 2000