hi to all,

i'm using a sql-receive to get data out of a sql server database. however, i
need these data sets within a convoy.

the problem is that i cannot promote the schema fields to use them in a
correlation set because of the errormessage:"...node can occur potentially
multiple times...".

is there a workaround or do you see anything i'm doing wrong??
thanks in advance

hendrik

[ Post a follow-up to this message ]

By default the schema generation wizard will set the child record to
unlimited. If you know that you are only going to be getting on record,
change the max to 1 and then you should not have a problem in your
promotion.

Eric
Why don't you ever see the headline "Psychic Wins Lottery"?
"theonlyhenni" <theonlyhenni@discussions.microsoft.com> wrote in message
news:AF181049-3AAC-4836-B38B-3CDBCDAAA0DB@microsoft.com...
> hi to all,
>
> i'm using a sql-receive to get data out of a sql server database. however,
> i
> need these data sets within a convoy.
>
> the problem is that i cannot promote the schema fields to use them in a
> correlation set because of the errormessage:"...node can occur potentially
> multiple times...".
>
> is there a workaround or do you see anything i'm doing wrong??
> thanks in advance
>
> hendrik

[ Post a follow-up to this message ]

thanks.

but what can i do to receive multiple sets???

hendrik

"Eric Stott" wrote:

> By default the schema generation wizard will set the child record to
> unlimited. If you know that you are only going to be getting on record,
> change the max to 1 and then you should not have a problem in your
> promotion.
>
> Eric
> Why don't you ever see the headline "Psychic Wins Lottery"?
> "theonlyhenni" <theonlyhenni@discussions.microsoft.com> wrote in message
> news:AF181049-3AAC-4836-B38B-3CDBCDAAA0DB@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

you could call the stored proc, recieve the multiple set result, and then
use a loop shape to loop through each of the rows, extracting the individual
row and then using promoted properties in the individual message. This, then
will allow you to have promoted properties.
I have two examples that I have blogged about that show somewhat how to do
it:
http://www.stottcreations.com/blog/biztalk-tidbits/
http://www.stottcreations.com/blog/...me-on-my-hands/

Eric
http://stottcreations.com/blog

The meek are getting ready...

"theonlyhenni" <theonlyhenni@discussions.microsoft.com> wrote in message
news:502A4C06-EDF7-47D5-93DB-AA5DF5A9324E@microsoft.com...[vbcol=seagreen]
> thanks.
>
> but what can i do to receive multiple sets???
>
> hendrik
>
> "Eric Stott" wrote:
> 

[ Post a follow-up to this message ]