To read dynamically changing file names using FTP task

• kk.86manu

  Ten Centuries

  Points: 1268

  More actions

  December 19, 2011 at 4:09 am

  #252371

  Hi All,

  I used a FTP task to read a text file from a FTP destination and i was able to successfully download a single file to my local path.My problem is the name of the file changes(filename_YYYYMMDD.txt) everyday.How can we address this scenario in the FTP task?

  Your help would be appreciated.

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  December 19, 2011 at 5:36 am

  #1423061

  kk.86manu (12/19/2011)

  ---

  Hi All,

  I used a FTP task to read a text file from a FTP destination and i was able to successfully download a single file to my local path.My problem is the name of the file changes(filename_YYYYMMDD.txt) everyday.How can we address this scenario in the FTP task?

  Your help would be appreciated.

  You can put an expression on the property that stores the filename.

  http://msdn.microsoft.com/en-us/library/ms141232.aspx

  An example on how to create the timestamp:

  http://consultingblogs.emc.com/jamiethomson/archive/2007/02/07/SSIS-Nugget_3A00_-Construct-a-timestamp-value.aspx

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