Header Question - round 2... nobody responded

Tech-Archive recommends: Fix windows errors by optimizing your registry

No one responded the 1st time I posted, so I'm trying again, thanks!


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 am NOT using an orchestration. I just use the map and the pipeline on
the send port, and then add a filter to the send port to 'listen' to the
receive port that runs the SPROC.

Here is my issue. My header in my output flat file does NOT contain the
total number of records that is coming from the stored proc. I know the
SPROC is returning the results correctly, I tested that.

This is what I tried... I tried to do this using an orchestration, but I get
the same results, I use the transform to create the Header and document
messages, then I have 2 send shapes/port types... 1 for the header, 1 for
the main document. In the orchestration, I tried to bind them to the same
send port (the one that uses the send pipeline), but I still don't get the
correct information on the header.

Any and all suggestions welcome!

Brian


.

Relevant Pages

  • Header Question revisited...
    ... select (I need this information for the header record in my flat file output ... I have a send pipeline that sets the document schema and the header ... schema (for the output document). ... I have a map that has the SPROC schema for the 'Source' and I have the ...
    (microsoft.public.biztalk.general)
  • Header Question Round 3...
    ... select (I need this information for the header record in my flat file ... I have a send pipeline that sets the document schema and the header ... schema (for the output document). ... I have a map that has the SPROC schema for the 'Source' and I have the ...
    (microsoft.public.biztalk.general)
  • Header question...
    ... select (I need this information for the header record in my flat file output ... I have a send pipeline that sets the document schema and the header ... schema (for the output document). ... I have a map that has the SPROC schema for the 'Source' and I have the ...
    (microsoft.public.biztalk.general)
  • Re: Header Question - round 2... nobody responded
    ... file assembler with both the header schema and body schema. ... >I thought the flat file assembler would deal with headers as well (but I ... >>> schema (for the output document). ...
    (microsoft.public.biztalk.general)
  • Re: Flat File Problem
    ... It was the namespace I was using to ... When I debug the orchestration the RecCount variable is null. ... Have you deployed the Biztalk Assembly that contains the property schema ... And you can promote properties from the Header into the message context, ...
    (microsoft.public.biztalk.general)