Need to create folder in destination location thru ftp task

• NLV

  SSChasing Mays

  Points: 654

  More actions

  September 7, 2011 at 8:04 am

  #257011

  Hi,

  I am posting one file from source location to destination location thru FTP Upload task in SSIS. While posting I want to create a current date folder in mm-dd-ccyy format at destination location and then post the file into the mm-dd-ccyy folder.

  Please advice.

  Thanks

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  September 7, 2011 at 7:14 pm

  #1378330

  NLV (9/7/2011)

  ---

  Hi,

  I am posting one file from source location to destination location thru FTP Upload task in SSIS. While posting I want to create a current date folder in mm-dd-ccyy format at destination location and then post the file into the mm-dd-ccyy folder.

  Please advice.

  Thanks

  Hi,

  It is possible, but requires implementing a script. Check these links for reference:

  http://www.cozyroc.com/script/ftps-task

  http://www.cozyroc.com/script/get-ftp-file-list-task

  http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.ftpclientconnection_members(v=SQL.90).aspx

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