Hi ,
My requirement is I am getting 3 source files with same meta data and I have to design one job in that I have to load these files one after the other.In the Target table I have to append the Seconefile Data to the first file and so on..
While reading the first file if i encounters any problem then I have to read from the second file and so on..
I have to dsign this in one job......
Can any one help me regarding this?
Thanks and Regards
Siva
Execute Same Job with 3 files?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Wed Mar 17, 2004 3:33 am
Re: Execute Same Job with 3 files?
Funnel the three files in the order you wish, by choosing the funnel option as Sequence, so that the data from the first file is done first, followed by second, and then the third. Between the file and funnel, you can have a transformer so that any errors in the files are bypassed...Hope this is what you look for and it helps.shivakumar wrote:Hi ,
My requirement is I am getting 3 source files with same meta data and I have to design one job in that I have to load these files one after the other.In the Target table I have to append the Seconefile Data to the first file and so on..
While reading the first file if i encounters any problem then I have to read from the second file and so on..
I have to dsign this in one job......
Can any one help me regarding this?
Thanks and Regards
Siva
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Re: Execute Same Job with 3 files?
Designing one job and as noted calling it as multiple instance thrice will be the best option. If you try to read all the files in one job and if one of the file is having any problem in reading then your whole job will fail, which you do not want to happen.
shivakumar wrote:While reading the first file if i encounters any problem then I have to read from the second file and so on..
I have to dsign this in one job......
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia