-
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?
Read Best Answer
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.priyank_divya
- Aug 3rd, 2012
There is a concept of Indirect filelist for processing multiple files with similar structure.
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
-
Data Loading While Session Failed
If there are 10000 records and while loading, if the session fails in between, how will you load the remaining data?
reddykuruganti
- Jun 7th, 2010
Simply you can restart the session, by selecting truncate table option in the session properties.
