SSIS FTP TASK - Change Remote Directory and Upload Files

• princa

  SSCommitted

  Points: 1819

  More actions

  January 10, 2011 at 9:41 am

  #232028

  Hi All,

  I am facing a problem while I am using SSIS FTP task to upload a file:

  Based on certain permission on remote FTP, the default ftp path for my username is say "ftp://xxx/", which is not necessary the root.

  Then I need to upload a file to another path rather than my account's default path:

  Under FTP command line:

  CD ..

  CD foldername

  PUT filename

  So, how could we implement this in SSIS FTP task? So that we could login as regular account and change remote directory and then upload file.

  Or anyone knows how to do it in Vb.net?!

  Thanks a lot!!! 😀

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  January 14, 2011 at 12:37 pm

  #1273745

  Use expression to dynamically modify FTP Task's RemotePath parameter to the location where you want to upload a file.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  

• dschoeff 59082

  SSC Rookie

  Points: 35

  More actions

  August 30, 2011 at 3:37 pm

  #1375264

  I have the same problem princa has

  I need to use the cd .. command to navigate one folder up from my default directory. Can I use an expression to do this in the RemotePath property?