Dataflow In a Infinite Loop searching for any Flat file Existance.

Job Is executed 1 time.

Check for Any Flat file(Column structure will be same) exists in "X" Folder.
Name of the flat file changes every time. But the Column Structure will be same.
If any Flat file exists then Dataflow will be executed.
Once the data is loaded into the target table the Source flat file in "X" folder should be deleted.
Dataflow will be in a Infinite Loop searching for any Flat file Existance.


Place a Script & fill the following code:$G_Stop =1;Place a While Loop Icon i.e available on the right hand side slider:put the following condition :

($G_Stop = 1)

Inside the While Loop :

Place a Script & fill the following code :exec('D:\Flat\b.bat','',2);

$G_a =file_exists('D:\zz.txt');
Code of b.bat :
cd\

d:

cd d:\flat

if not exist *.txt del d:\zz.txt

if exist *.txt dir > d:\zz.txtPlace a Conditional Icon next to the Script :

Put the following condition :($G_a=1)Inside the If Condition :

Place the Dataflow which u want to execute.

Next to it place a script and fill the following code.exec('D:\Flat\Del_Flat.bat','',2);

Code of Del_Flat.bat :

cd\
d:
cd d:\flat
del *.txt