Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmallain
Starting Member
5 Posts |
 Posted - 2008-08-20 : 16:31:44
|
| 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 xlsWin32 process: C:\Program Files\WinZip\WINZIP32.EXEParameters: c:\temp\claims.xls c:\temp\claims.zipReturn Code: 0Timeout: 0When 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!CarolGo to Top of Page |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-20 : 22:57:31
|
| Should it be easier to do outside of dts? |
 |
|
|
cmallain
Starting Member
5 Posts |
Posted - 2008-08-21 : 00:25:41
|
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. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-21 : 23:08:58
|
| Didn't say do it manually. You can use cmdexec process to unzip file in sql job, much easier to do. |
|
|
|
|
|
|
WinZip in a DTS package