| Brian C 2004-12-28, 5:49 pm |
| 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
|