Post reply

SSIS DTSX Package Run bat file to FTP

  • October 22, 2014 at 1:52 pm

    #312467

    I have a step in my dtsx package that executes a batch file. The batch file compresses files into a zip and then uses psftp to send them. It works until it tries to send the file. IT says local: unable to open file name. Does anyone know what could be causing this.

  • October 23, 2014 at 7:36 am

    #1754340

    I figured it out. I did not set the "working directory" property for the execute process task to the directory where the file was that was being sent to the ftp site. Also I realize that I am am working in SQL 2008 and not SQL 2005. :hehe:

    Sorry for any confusion.

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

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