SSIS: Moving files to subdirectory on remote client FTP server

• guri31

  SSC Veteran

  Points: 211

  More actions

  September 29, 2011 at 1:47 am

  #390507

  Hi all, i am really hoping i could get some help on this.

  I have a FTP access to client FTP server from where i need to copy the files to our local server and then move the file from origional source location to one of the sub-directories.

  I have already created the FTP task which copies the file to our local server, but couldn't figure out how to move the same file from its source location to one of the sub-directories.

  much appreciate your help 🙂

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  September 29, 2011 at 6:09 am

  #1388310

  [font="Verdana"]From your post, what I understood is you need to copy some files from FTP location to local location first and then FTP the same files to FTP again. You can use / add script task and write a .Net code for copying the files to and from location. For more info: http://www.simple-talk.com/sql/ssis/quick-tip-performing-an-ftp-rename-in-a-ssis-script-task/

  you can refer this article to COPY the files...

  Thanks,

  -- Mahesh[/font]

  MH-09-AM-8694