December 19, 2011 at 4:09 am
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.
December 19, 2011 at 5:36 am
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:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply