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?
Printable View
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?
[QUOTE=rameshpossible;]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?[/QUOTE]
Good Question *Ramesh* -
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.