I'm new to BTS, and would like to know how to handle this situation

1)  I need to have a receive port that runs a stored proc on a daily basis
that does a select of certain records (I have this part done)

2)  I need to create a flat file from the stored proc in step 1 and send it
to an FTP site (I have this part done)

3)  I also need to run an 'insert' stored proc that will take 2 fields from
the records I received (from stored proc in step 1).  (not done)


I started out just tackling step 1 and 2 without an orchestration and that
worked fine, then I put steps 1 and 2 into an orchestration and what happens
now is that I receive 2 flat files instead of just 1.  I have no idea how to
incorporate step 3.  Do I need an orchestration to do all 3 steps, or is
there a better way?  Step 3 needs to use the records from step 1 (in case
you need to know that)

thanks in advance, Brian

[ Post a follow-up to this message ]