Return Multiple Columns From a SQL Table
RitaG
I'm able to return a single column (defined as XML) into BizTalk 2006 from a
SQL 2005 table using the "Any" data type in a schema (a Stored Procedure is
executed from a "Receive Location"). However, I now need to return the XML
column along with a couple of columns and cannot figure out how to do it.
Any suggestions will be greatly appreciated!
Thanks,
Rita
Brian Jones
Why not use the Schema Generation Wizard in BTS 2006 and let BizTalk create
a schema for you? This way, you can either define the SQL Statement or
Stored Procedure to execute and half your battle is resolved. Certainly,
you will have to ensure your SQL or SPROC returns XML, and during the Schema
Generation you will have to append your SQL with XMLDATA. For Example: FOR
XML AUTO, XMLDATA. This information is used to generate the actual XML
Schema.
HTH
--
Brian Jones
http://bajwork.blogspot.com
RitaG
Many thanks for your suggestion. I was able to get it to work correctly.
I'm only into using BizTalk for six weeks now and have lots to learn!
Rita
Jan Eliasen
wrote:
>Glad I could help. Don't worry... I've been doing it since 2004 and I'm
>still learning. :)
I have you beaten by a year! .-)
--
eliasen, representing himself and not the company he works for.
Private blog: http://blog.eliasen.dk
Private email: j...@eliasen.dk
Brian Jones
379. It is not good to have too much liberty. It is not good to have all one
wants.
380. All good maxims are in the world. We only need to apply them. For
instance, we do not doubt that we ought to risk our lives in defence of the
public good; but for religion, no.
It is true there must be inequality among men; but if this be conceded, the
door is opened not only to the highest power, but to the highest tyranny.
We must relax our minds a little; but this opens the door to the greatest
debauchery. Let us mark the limits. There are no limits in things. laws
would put them there, and the mind cannot suffer it.
381. When we are too young, we do not judge well; so, also, when we are too
old. If we do not think enough, or if we think too much on any matter, we
get obstinate and infatuated with it. If one considers one's work
immediately after having done it, one is entirely prepossessed in its
favour; by delaying too long, one can no longer enter into the spirit of it.
So with pictures seen from too far or too near; there is but one exact point
which is the true place wherefrom to look at them: the rest are too near,
too far, too high or too low. Perspective determines that point in the art
of painting. But who shall determine it in truth and morality?
382. When all is equally agitated, nothing appears to be agitated, as in a
ship. When all tend to debauchery, none appears to do so. He who stops draws
attention to the excess of others, like a fixed point.
383. The licentious tell men of orderly lives that they stray from nature's
path, while they themselves follow it; as people in a ship think those move
who are on the shore. On all sides the language is similar. We must have a
fixed point in order to judge. The harbour decides for those who are in a
ship; but where shall we find a harbour in morality?
384. Contradiction is a bad sign of trut