I've almost got this one, but nee help 1 more time...

Here is my scenario.

1) I run a stored procedure to get a list of disconnected phone numbers

2) in the SPROC  I also get the number or records that are returned from the
select (I need this information for the header record in my flat file output
file).

3) I have 3 schemas, 1 for the SPROC, 1 for the output document, 1 for the
header on the output document

4) I have a send pipeline that sets the document schema and the header
schema (for the output document).

5) I have a map that has the SPROC schema for the 'Source' and I have the
the output document AND the header for the output document as the
destination schema.  (I created the map using the transform shape in an
orchestration because that is the only way I know how to get multiple
schemas in the destination schema part of a map).

6) I have an orchestration.  In the orchestration I call the SPROC, use a
transform shape that applies the map in step 5.  The output file I'm trying
to creates is a multipart message (with both header and body parts, the
latter marked as body in the type definition)

Here is the problem... I get an output file, but the header record is not
being populated from the SPROC.  I have verified that the SPROC is returning
the correct results.  For some reason, when the map is being applied, the
results are not 'Staying' in my destination schema.  I'm very confused as to
why I'm not seeing the correct results in
my header.

I tried to attach the project, but I get an error message when trying to
post... If you would like me to send you the project in a .zip file, please
send me an email and I will reply with the attachment.


Any and all help is appreciated!

Thanks

Brian

[ Post a follow-up to this message ]