Timeout Expired when using xp_cmdshell in DTS

• Tracy Tan

  SSC Enthusiast

  Points: 194

  More actions

  June 13, 2007 at 1:02 pm

  #174087

  I have a DTS package which one of the step is calling a stored procedure, which inside it using xp_cmdshell to call an FTP script to ftp bunch of files to another server.

  If the file list is small (1~250, 2KB each) then the whole DTS process run well, but when the file list grow bigger (250+) then it always failed on the xp_cmdshell part...., return this error message "Timeout Expired". I have already change the timout in the sqlserver connection to 0, but it doesn't seems to affect the xp_cmdshell part...

  Any idea? I been searching for answer for a long time and just couldn't find the answer anyway... Maybe I'm going the wrong direction? Maybe I shouldn't use xp_cmdshell after all?

  Thanks in advance for your help!

  TT

• Jason-

  SSCrazy

  Points: 2764

  More actions

  June 13, 2007 at 5:09 pm

  #712789

  Try using execute process task.

  By setting the connection timeout to 0 you shouldn't time out, sounds like the command called in xp_cmdshell may be timing out...

  Again though, try using an Execute Process Task, it might help

  -