Need help ion ssis FTP task

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  February 15, 2012 at 9:18 am

  #268432

  Hi Guys,

  I am trying to cerate a file in my local machine and then FTP it to a diffeerent server but i need to rename it and place it in the FTP folder ..Is ther a way to rename the file on the fly ...Please adivde the best way to do it ?

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  February 16, 2012 at 12:21 am

  #1447681

  If you can rename the file locally, check out the File System Task.

  It has the option "rename".

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP