Hi,
I have a file directory path were I get a csv file per day, with current date. I have set up Flat File Connection manager that uses expression to access that location. When I execute I get an error that it cannot open datafile.
The problem is, my path doesn't include the filename itself, and I don't understand how should I include file name because the file name changes daily, since it comes with different dates. e.g today's file Generic20170928100320.csv, tomorrow's file Generic20170929110523.csv
PS: I can also receive files with previous dates and time, e.g Generic20170914110720.csv
How do I fix this.
I have a file directory path were I get a csv file per day, with current date. I have set up Flat File Connection manager that uses expression to access that location. When I execute I get an error that it cannot open datafile.
The problem is, my path doesn't include the filename itself, and I don't understand how should I include file name because the file name changes daily, since it comes with different dates. e.g today's file Generic20170928100320.csv, tomorrow's file Generic20170929110523.csv
PS: I can also receive files with previous dates and time, e.g Generic20170914110720.csv
How do I fix this.