zip a file: task in a DTS package

[DBAchick]

I would like to be able to zip a file using WinZip or PKZip as step one of my DTS package.

I assume I will need to do this in an active X task as it will require a commmand line call to the winzip or pkzip.exe.

Am I headed down the right path or is this beyond the capabilities of DTS?

Any help is appreciated!

 

[tlbroadbent]

You should be able to execute the ZIP program using the Execute Process Task in DTS. Make sure all required parameters are supplied. If the program displays a screen or prompts for input, it will hang when run on the server as a Job.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[pabloj]

You can use the free&open zlib library, see

http://patb.dyndns.org/Programming/ZlibVB.htm

Stick to your guns

 

[OutInLeftField]

go to wrox or

http://www.stonebroom.com.

They have a component called "StoneBroom" Zip component. It works very well...A little confusing but once you learn its methods, it works.