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 ]