Problem with FTP Task in SSIS on SQL2005

• juan.maart

  SSC Rookie

  Points: 25

  More actions

  October 6, 2010 at 6:38 am

  #1232446

  S.K. You are such a legend!!! I have been battling for 4 days to get the schedule to work. I have tried xml config files and the like and your SIMPLE solution was exactly what was needed. Thank you soooo much!!!

• jamirphillips-790261

  SSC Veteran

  Points: 208

  More actions

  January 4, 2011 at 1:08 pm

  #1269180

  Thanks a bunch. This worked like a charm.

  Jamir Phillips

• sahoong

  SSCrazy

  Points: 2545

  More actions

  August 9, 2011 at 7:35 am

  #1365898

  i have created an ftp task and the connection works. i want to use the ftp task to move a data. the file is on my desktop. how can i point the ftp task to the file on my desktop for it to be transferred to the remote server.

  thanks for your help

• Lady SQL

  SSC Veteran

  Points: 261

  More actions

  December 7, 2011 at 5:54 pm

  #1418441

  This is what I did to solve the dilemma.

  I created the configuration file on SQL Server. (exporting FTP Connection only so I didn't get too overloaded with rows)

  When you create a configuration file in the project as SQL Server, it will create a table.

  The table will have Password; the table passes the literal '*****' as seen in the project.

  I put in the password

  re-deployed and voila!

  FINALLY it worked.