Hello,

I have a dts job, based on a Transact-Sql BACKUP command, which produces
regularly a backup file.

Immediately after it, another task should compress (zip) this file.

Which is the best way to realize this and which compress programm must be
used so it is compatibel with WinZip?

Thanks,
Hubert

If you have a registered copy of WinZip, then you can download the command
line version of it and just zip the file through an Exec Process task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Hubert Rétif" <retif.hubert (AT) hispeed (DOT) take.this.away.ch> wrote

Hello,

I have a dts job, based on a Transact-Sql BACKUP command, which produces
regularly a backup file.

Immediately after it, another task should compress (zip) this file.

Which is the best way to realize this and which compress programm must be
used so it is compatibel with WinZip?

Thanks,
Hubert

In message <#gEQ#Vm8EHA.3820 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Tom Moreau
<tom (AT) dont (DOT) spam.me.cips.ca> writes
For a backup personally I would use SQL LiteSpeed (www.imceda.com) to
achieve this, but then I use it anyway. Save you the hassle of a
separate zip step.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thanks Tom and Darren. Exactly the kind of information I was looking for.