|
| 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
|
|