|
Subject:
|
Issues with xp_cmdshell
|
|
Posted By:
|
ninel
|
Post Date:
|
8/25/2006 11:02:07 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
|
|
Reply By:
|
Peso
|
Reply Date:
|
8/26/2006 9:39:49 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.
|
