| Matt Milner 2004-07-27, 5:53 pm |
| 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
>
>
|