Passing parameters to a nested loop
Posted: Wed May 21, 2008 11:42 pm
Hi, Everyone
Can anyone suggest a solution to the following scenario.
I have more than 100 csv files as my sources. all of them are of same structure.
I need to extract the data from all these files into a table with the file name as an added field.
Number of files in the folder are not constant. and the file names may change every time .
flat file---->transformer----->table.
Can I put this job into a nested loop and pass the file name as parameter into it. and the loop should run till all the files in the folder are extracted(I need to use a job after sub routine to move the files after extraction).
Is this works? If works, How can we pass the file name parameters into the job?.
Thanks in Advance,
Kalpana.
Can anyone suggest a solution to the following scenario.
I have more than 100 csv files as my sources. all of them are of same structure.
I need to extract the data from all these files into a table with the file name as an added field.
Number of files in the folder are not constant. and the file names may change every time .
flat file---->transformer----->table.
Can I put this job into a nested loop and pass the file name as parameter into it. and the loop should run till all the files in the folder are extracted(I need to use a job after sub routine to move the files after extraction).
Is this works? If works, How can we pass the file name parameters into the job?.
Thanks in Advance,
Kalpana.