Indirect file loading

First lets see how to do indirect file loading.

0)import a flat file and create a mapping to load the flat file data to target.The source you are seeing here below is a flat file.

1)In session you need to set the path of the directory(in fig below see 'source file directory'); which contains a file(in fig below see 'source file name'); having paths to the files which you want to load to target.

With in the text file here it is Path.txt.You need to set the path of the file which you want to load as follows,

one more thing don't forget set the source file type as indirect in Edit Task of session.