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.
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.