How can I specify a pattern to pick and read a file without specifying the full file name?
My source system send me a file daily but each day the name of the file is appended with the date on which it’s send, like <source system name>_mmddyyy. How can I specify only the first part of the name excluding the date part so that the file is picked up and processed?
This can be achieved in multiple ways using parameterization concepts for file name based on the exact requirement. Below is an basic solution to achieve it,
1. Create a dataflow with File as a source and required database as a target.
2. Select File source instance in dataflow and click on ‘Extraction Properties’ tab in design tab.
3. Give ‘File Name’ with pattern as only source system name_* and choose ‘File data reference’ as wildcard.
4. Execute the dataflow.
5. Further it can be scheduled in schedular module to trigger dataflow automatically everyday.