Multiple Flat Files Loading

If there are multiple source flat files with different names but same file structure. How do we load all those files to the target in one step?

Questions by win_bhatia   answers by win_bhatia

Editorial / Best Answer

etluser  

  • Member Since Dec-2009 | Dec 31st, 2009

Follow the below steps-
1. Create the mapping as if there is only single source and target.
2. Now create an additional file on the server which will list the multiple source file names along with their paths.
3. Specify the path and name of this file in the "Source File" under session properties. 
4. Now the most important thing - Set "Source Filetype" as "indirect" under session properties.

Showing Answers 1 - 9 of 9 Answers

etluser

  • Dec 31st, 2009
 

Follow the below steps-
1. Create the mapping as if there is only single source and target.
2. Now create an additional file on the server which will list the multiple source file names along with their paths.
3. Specify the path and name of this file in the "Source File" under session properties. 
4. Now the most important thing - Set "Source Filetype" as "indirect" under session properties.

Rajath

  • Feb 20th, 2012
 

What if there are n source files(number may vary) with the same structure? File name maybe similar for e.g. TxtFile_1,TxtFile_2,TxtFile_3...........TxtFile_n

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions