Issues with xp_cmdshell

• ninel

  Ten Centuries

  Points: 1087

  More actions

  August 25, 2006 at 9:58 am

  #116473

  I have an xls file that is about 358 kb and contains about 1569 rows.

  I am using the following 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

• shardul shah-338572

  Grasshopper

  Points: 14

  More actions

  August 25, 2006 at 3:09 pm

  #656956

  Map that server or map that drive and than try it..

  sshah