|
Home > Archive > BizTalk Server Orchestration > June 2006 > problems when promoting items from a generated schema
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problems when promoting items from a generated schema
|
|
| theonlyhenni 2006-06-12, 1:18 pm |
| 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
| |
| Eric Stott 2006-06-12, 7:17 pm |
| 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
| |
| theonlyhenni 2006-06-13, 7:22 am |
| 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...
>
>
>
| |
| Eric Stott 2006-06-13, 1:18 pm |
| 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:
>
|
|
|
|
|