Albert:

I use 7zip and that step NEVER fails unless I've made an error in the batch
file. The automated zip and unzip steps have been flawless for me. What I
did for those steps was to create a batch file which I then call from a DTS
step (execute process). I then call that dts from my job.

Carolyn J.


Albert Frazer wrote:

>Carolyn,
>
>I'm using basic move command and it is contained in a batch file which
>I execute as T-SQL command with xp_cmdshell. The bottleneck definitely
>is the zip-unzip step.
>


MS Sql Server LazyDBA home page