Error in execution of xp_cmdshell command

• sethubala78 45317

  SSC Rookie

  Points: 44

  More actions

  October 28, 2010 at 6:29 am

  #240314

  Hi All,

  When i execute the below script in sql server 2005, its working fine.

  declare @ss varchar(8000)

  set @ss='"C:\Progra~1\PKWARE\pkunzip" -e -o -d \\SPIR103\ftpdata\PoTracking\Receiving\MCE\pohb-MCE.zip \\spir103\ftpdata\Schedule_MST\ReceivingFordissss\MCE\'

  exec master.dbo.xp_cmdshell @ss

  After that i increased two character in the filename like

  \ftpdata\Schedule_MST\ReceivingFordissssAA\MCE\'

  So i get the below script,

  declare @ss varchar(8000)

  set @ss='"C:\Progra~1\PKWARE\pkunzip" -e -o -d \\SPIR103\ftpdata\PoTracking\Receiving\MCE\pohb-MCE.zip \\spir103\ftpdata\Schedule_MST\ReceivingFordissss\MCE\'

  exec master.dbo.xp_cmdshell @ss

  i getting the error message like that 'The system cannot execute the specified program.'

  If any limitation is there.

  Please give the solution for that problems.

  Thanks,

  G.Sethuraj.