Hi,

In my orchestration, i have to send some data(100 fields) to one table
called X. Before sending this i have to check whether the data exists in the
table or not(18 fields). If not exists then insert it in x table.

How to do this in optimized way using SQL adapter

Thanks
Sents

[ Post a follow-up to this message ]

You could send the XML as a blob to SQL and then do insert/update logic
using OPENXML in the stored procedure to insert new rows and update existing
ones.  I've got a sample on my blog that shows how to pass XML as a
parameter to a stored procedure.

matt
http://www.m3technologypartners.com/blogs/


"Sents" <Sents@discussions.microsoft.com> wrote in message
news:493AE61D-C859-4FDE-89F0-5F2D5A8748B6@microsoft.com...
> Hi,
>
> In my orchestration, i have to send some data(100 fields) to one table
> called X. Before sending this i have to check whether the data exists in
> the
> table or not(18 fields). If not exists then insert it in x table.
>
> How to do this in optimized way using SQL adapter
>
> Thanks
> Sents

[ Post a follow-up to this message ]

Thanks Matt. I will try this.

I have made a return value field as distinguish field . How will i access in
decide shape.
It gives as Mutiresmsg.parameters thats it. it is not displaying field.??

Regards
Senthil

"Matt Milner" wrote:

> You could send the XML as a blob to SQL and then do insert/update logic
> using OPENXML in the stored procedure to insert new rows and update existi
ng
> ones.  I've got a sample on my blog that shows how to pass XML as a
> parameter to a stored procedure.
>
> matt
> http://www.m3technologypartners.com/blogs/
>
>
> "Sents" <Sents@discussions.microsoft.com> wrote in message
> news:493AE61D-C859-4FDE-89F0-5F2D5A8748B6@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

You have to do MPMessage.partname.distinguishedFieldName. This should give
you what you need.

matt


"Sents" <Sents@discussions.microsoft.com> wrote in message
news:89C26C45-A32E-42DF-BB7C-3E7A18E24E86@microsoft.com...[vbcol=seagreen]
> Thanks Matt. I will try this.
>
> I have made a return value field as distinguish field . How will i access
> in
> decide shape.
> It gives as Mutiresmsg.parameters thats it. it is not displaying field.??
>
> Regards
> Senthil
>
> "Matt Milner" wrote:
> 

[ Post a follow-up to this message ]