Hi All

I am using SQL Receive in my orchestration (select Product from DFS_lead).

The Product Column is of lookup type.

I want to implement multiple if statements in my orchestration

Product          CRMProductLine         CRMPriorityCode

P232                              11                                        
             22

P301                              33                                        
              44

............

.............

If i get a Product of P232 the output message should be

<CRMData>

<opportunity>

..

...

<CRMProductLine>11</CRMProductLine>

<CRMPriorityCode>22</CRMPriorityCode>

</opportunity>

</CRMData>

and If i get a Product of P301 the output message should be

<CRMData>

<opportunity>

..

...

<CRMProductLine>33</CRMProductLine>

<CRMPriorityCode>44</CRMPriorityCode>

</opportunity>

</CRMData>



This is possible through the use of Database functiods (most probably by usi
ng Format Message functiod)

I used the tool BTSXRefImport.exe which accepts some predefined xml files fr
om which it fills the tables in BiztalkMgmtDb which will act as lookup table
s.

I am not able to continue further as there are no samples available in micro
soft website.

Can anyone help me in this regard



Regards

Guru

[ Post a follow-up to this message ]

if you are using BizTalk 2004, this sounds like the business rules engine
might work for you as well.  it is a bit more flexible than the mapper and
can be changed on the fly without having to redeploy your maps.

Matt


"Guru" <Guru@discussions.microsoft.com> wrote in message
news:85B48D38-C31A-44A0-8B92-C676923AE88A@microsoft.com...
> Hi All
>
> I am using SQL Receive in my orchestration (select Product from DFS_lead).
>
> The Product Column is of lookup type.
>
> I want to implement multiple if statements in my orchestration
>
> Product          CRMProductLine         CRMPriorityCode
>
> P232                              11
22
>
> P301                              33
44
>
> ............
>
> .............
>
> If i get a Product of P232 the output message should be
>
> <CRMData>
>
> <opportunity>
>
> ..
>
> ...
>
> <CRMProductLine>11</CRMProductLine>
>
> <CRMPriorityCode>22</CRMPriorityCode>
>
> </opportunity>
>
> </CRMData>
>
> and If i get a Product of P301 the output message should be
>
> <CRMData>
>
> <opportunity>
>
> ..
>
> ...
>
> <CRMProductLine>33</CRMProductLine>
>
> <CRMPriorityCode>44</CRMPriorityCode>
>
> </opportunity>
>
> </CRMData>
>
>
>
> This is possible through the use of Database functiods (most probably by
using Format Message functiod)
>
> I used the tool BTSXRefImport.exe which accepts some predefined xml files
from which it fills the tables in BiztalkMgmtDb which will act as lookup
tables.
>
> I am not able to continue further as there are no samples available in
microsoft website.
>
> Can anyone help me in this regard
>
>
>
> Regards
>
> Guru
>
>

[ Post a follow-up to this message ]