Issues with xp_cmdshell

ninel · August 25th, 2006, 11:02 AM

I have an xls file that is about 358 kb and contains about 1569 rows.
I am using the following code:

Code:

Use master
DECLARE @reult varchar(200)

EXEC @result = xp_cmdshell '\\ITITPAFS02\pds\voicenet\isiti\winzip\wzzip.exe \\ititpafs01\pds\inetpub\ftproot\accumen\political  \at0123.zip \\ititpafs01\pds\inetpub\ftproot\accumen\political  \at0123.xls'

IF (@result = 0)
     PRINT 'success'
ELSE
     PRINT 'Failure'

It runs longer than 9 min. I just kill it. Am I doing something wrong?

Thanks,
Ninel

Peso · August 26th, 2006, 09:39 AM

Slow network?

You open the file on one server, and zips it to another server. That takes time.
Try to zip on same server, and when done, move the file.