Post reply

Help! Dos 255 Error from DTS Execute Process task

  • January 27, 2006 at 2:33 am

    #170309

    Hi,

    I'm running a secure FTP session from an execute process task. This process completes intermittently OK but most of the time it returns an error code of 255. There is nothing in the FTP log files which indicates that it's not reaching the FTP call.

    The FTP I'm using is Putty which is a GNU licenced product -  it is called via a DOS batch script (see below)

    If it plain wasnt working I could understand it, but because it only works intermittently I'm not sure what the problem is. If I run it outside DTS it works 100% of the time.

    Any ideas appreciated.

    Andy

     

     

     

     

     

  • January 30, 2006 at 10:18 am

    #617770

    Who/what starts the job? sql agent?

  • February 6, 2006 at 1:09 am

    #618906

    Hi,

    The job is started by a batch DTSRUN script initiated by Windows Scheduler. It is run as a service account that has local admin rights on the box.

    Regards,

    Andrew

     

  • February 6, 2006 at 10:53 am

    #619034

    Could it be a timeout?

  • February 7, 2006 at 1:10 am

    #619174

    Nope - I've got the timeout on the task and on the FTP both set to infinity.

     

    Thanks

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply