Brian, do you need to break the data received from SQL into seperate files?
If not, then you would not need to worry about envelopes, and you should
then be able to process the data through BizTalk in its entirety and produce
a flat file through the send pipeline for the entire set.

If you do want to utilise envelopes and you want to split the message
received from SQL, you need to set the Body XPath to the root node, as you
want to split on the dbo.SMSLog node.  Think of the Body XPath as the XPath
that will yield a Node whose children will be split into seperate messages.

--

Kind Regards,

Nabeel Prior
Web: http://www.brainjar.co.za
Blog: http://www.brainjar.co.za/blog.aspx


"Brian C" <brian.cesafsky@midwestwireless.com> wrote in message
news:uiNbJv25EHA.2016@TK2MSFTNGP15.phx.gbl...
>I have a receive port that calls a stored proc that will return multiple
>rows.  I need the output to be a flat file.  I have everything working
>except I only get the first row that is returned from the stored proc (only
>1 row of output in the flat file).  I've gone through an example of
>creating an envelope schema (the schema was first generated through the SQL
>adapter wizard), but I have issues.  I'm not sure how to set the 'Body
>Xpath' and the 'Data Structure Type' properties.  The 'Data Structure Type'
>property was set through the SQL adapter wizard, and I'm not sure if I
>should change it.
>
> I've attached the schema.
>
>
> Thanks in advace, Brian
>
>
>

[ Post a follow-up to this message ]

I don't want to break the data into separate files.  I am not using an
envelope schema, but I only get the 1 row of data even though there are
several rows coming from the SQL statement.  I have a map that I use to push
that data from the SQL generated schema to the flat file schema... I don't
know what I'm doing wrong... Any help would be appreciated.

[ Post a follow-up to this message ]

Have you hooked a file adapter based send port using the passthrough pipelin
e direct to the receive port using a filter just to ensure that you really a
re only getting one row and its not the map that just makes it appear that w
ay?

Regards

Richard Blewett - DevelopMentor
http://www.dotnetconsult.co.uk/weblog
http://www.dotnetconsult.co.uk

I don't want to break the data into separate files. I am not using an
envelope schema, but I only get the 1 row of data even though there are
several rows coming from the SQL statement. I have a map that I use to push
that data from the SQL generated schema to the flat file schema... I don't
know what I'm doing wrong... Any help would be appreciated.

[ Post a follow-up to this message ]

Good idea,  I just tried that and I am still just getting the 1 row.  What
else can I check?


Thanks...

Brian


"Richard Blewett [DevelopMentor]" <richardb@NOSPAMdevelop.com> wrote in
message news:%23poXuXE6EHA.3504@TK2MSFTNGP12.phx.gbl...
> Have you hooked a file adapter based send port using the passthrough
> pipeline direct to the receive port using a filter just to ensure that you
> really are only getting one row and its not the map that just makes it
> appear that way?
>
> Regards
>
> Richard Blewett - DevelopMentor
> http://www.dotnetconsult.co.uk/weblog
> http://www.dotnetconsult.co.uk
>
>   I don't want to break the data into separate files. I am not using an
> envelope schema, but I only get the 1 row of data even though there are
> several rows coming from the SQL statement. I have a map that I use to
> push
> that data from the SQL generated schema to the flat file schema... I don't
> know what I'm doing wrong... Any help would be appreciated.
>

[ Post a follow-up to this message ]

I take that back, somehow the map and pipeling I'm using makes me only get 1
record.  If I use a passthrough pipeline and just let the XML go to my
output directory, I see 2 records (my query returns 2 records).  Can you
help me find out what I'm doing wrong?

Thanks!



"Richard Blewett [DevelopMentor]" <richardb@NOSPAMdevelop.com> wrote in
message news:%23poXuXE6EHA.3504@TK2MSFTNGP12.phx.gbl...
> Have you hooked a file adapter based send port using the passthrough
> pipeline direct to the receive port using a filter just to ensure that you
> really are only getting one row and its not the map that just makes it
> appear that way?
>
> Regards
>
> Richard Blewett - DevelopMentor
> http://www.dotnetconsult.co.uk/weblog
> http://www.dotnetconsult.co.uk
>
>   I don't want to break the data into separate files. I am not using an
> envelope schema, but I only get the 1 row of data even though there are
> several rows coming from the SQL statement. I have a map that I use to
> push
> that data from the SQL generated schema to the flat file schema... I don't
> know what I'm doing wrong... Any help would be appreciated.
>

[ Post a follow-up to this message ]

Do you have a custom pipeline or are you using one of the built in ones? And
 do you have something like MinOccurs=1 MaxOccurs=1 in your target map?

Regards

Richard Blewett - DevelopMentor
http://www.dotnetconsult.co.uk/weblog
http://www.dotnetconsult.co.uk

I take that back, somehow the map and pipeling I'm using makes me only get 1
record. If I use a passthrough pipeline and just let the XML go to my
output directory, I see 2 records (my query returns 2 records). Can you
help me find out what I'm doing wrong?

Thanks!



"Richard Blewett [DevelopMentor]" <richardb@NOSPAMdevelop.com> wrote in
message news:%23poXuXE6EHA.3504@TK2MSFTNGP12.phx.gbl...
> Have you hooked a file adapter based send port using the passthrough
> pipeline direct to the receive port using a filter just to ensure that you
> really are only getting one row and its not the map that just makes it
> appear that way?

[ Post a follow-up to this message ]

I'm using a built in send pipeline


"Richard Blewett [DevelopMentor]" <richardb@NOSPAMdevelop.com> wrote in
message news:eGlvtOF6EHA.2032@tk2msftngp13.phx.gbl...
> Do you have a custom pipeline or are you using one of the built in ones?
> And do you have something like MinOccurs=1 MaxOccurs=1 in your target map?
>
> Regards
>
> Richard Blewett - DevelopMentor
> http://www.dotnetconsult.co.uk/weblog
> http://www.dotnetconsult.co.uk
>
>   I take that back, somehow the map and pipeling I'm using makes me only
> get 1
> record. If I use a passthrough pipeline and just let the XML go to my
> output directory, I see 2 records (my query returns 2 records). Can you
> help me find out what I'm doing wrong?
>
> Thanks!
>
>
>
> "Richard Blewett [DevelopMentor]" <richardb@NOSPAMdevelop.com> wrote i
n
> message news:%23poXuXE6EHA.3504@TK2MSFTNGP12.phx.gbl... 
>

[ Post a follow-up to this message ]

Ummm, which one? XmlTransmit or PassthruTransmit?

And can you post your target schema (or at least the relevant bits)?

Regards

Richard Blewett - DevelopMentor
http://www.dotnetconsult.co.uk/weblog
http://www.dotnetconsult.co.uk

I'm using a built in send pipeline

[ Post a follow-up to this message ]

ooohhh,ooohhh... I almost got it now... I get both records, but I need to
insert a CRLF some how.  I had my target schema defined wrong... When you
talked about  the MinOccurs=1 MaxOccurs=1 in my target map, I went looking
and found that I didn't have my schema set up correctly...

Thanks for all your help!

P.S.  how do insert a CRLF?


"Richard Blewett [DevelopMentor]" <richardb@NOSPAMdevelop.com> wrote in
message news:%23FDjXmF6EHA.208@TK2MSFTNGP12.phx.gbl...
> Ummm, which one? XmlTransmit or PassthruTransmit?
>
> And can you post your target schema (or at least the relevant bits)?
>
> Regards
>
> Richard Blewett - DevelopMentor
> http://www.dotnetconsult.co.uk/weblog
> http://www.dotnetconsult.co.uk
>
>   I'm using a built in send pipeline
>
>

[ Post a follow-up to this message ]

Have you tried setting the "Indented" property of the grid to "Yes"?

Regards

> Richard Blewett - DevelopMentor
> http://www.dotnetconsult.co.uk/weblog
> http://www.dotnetconsult.co.uk

ooohhh,ooohhh... I almost got it now... I get both records, but I need to
insert a CRLF some how. I had my target schema defined wrong... When you
talked about the MinOccurs=1 MaxOccurs=1 in my target map, I went looking
and found that I didn't have my schema set up correctly...

Thanks for all your help!

P.S. how do insert a CRLF?

[ Post a follow-up to this message ]