I have three flat file source and i want to process (ie load them) in single shot i.e., not one by one. How I can achieve this?
I have three flat file source and i want to process (ie load them) in single shot i.e., not one by one. How I can achieve this?
Good Question *Ramesh* -Originally Posted by rameshpossible;
This is very simple when your three Source flat files are under same location.
Keep all the three files in a directory first.
then Goto -> session properties -> Mappings tab ---> select Sources
In Source properties, under File Reader tab -> Provide the path of the file containing the path of 3 files.
Your loading completes.
If these three files are located at different places (Directories) - This will not solve.
Last edited by admin; 05-31-2013 at 07:20 AM.
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.