Re: Dynamic Values in a Map

Sorry I couldn't explain it.
Suppose we have this input:

<Records>
<Record ID="ID1"/>
<Record ID="ID2"/>
<Record ID="ID3"/>
</Records>

and we want to create two outputs (please note that we cannot make
decision about the value of status based on input)
<Records>
<Record ID="ID1" Status="Recieved"/>
<Record ID="ID2" Status="Recieved"/>
<Record ID="ID3" Status="Recieved"/>
</Records>

<Records>
<Record ID="ID1" Status="Posted"/>
<Record ID="ID2" Status="Posted"/>
<Record ID="ID3" Status="Posted"/>
</Records>

Francisco A. Gonzalez wrote:
A Basic solution that maynot work for you is the following:

use a script functoid, the input and output is the "status".
Do something like (pseudo code): if ((status!="Posted") &&
(status!="UnderReview") status="Received";

if(status=="Posted") status="Under Review";
if (status=="Received") status="Posted";

There is a way to do it using other fucntoids but with an inline script in
visual basic or C# is so easy.

This solution may not work for you. Maybe You have to insert the uniques
id's in a database to store what theirs status is. Or maybe you have to use
correlation.

Francisco A. Gonzalez
fgonzalez@xxxxxxxxxxxxxxxxxxxxxxxx






"Billa" <BillaTilla@xxxxxxxxx> wrote in message
news:1165465206.093466.268880@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Francisco,
Suppose here is simplified scenario. We get some data, say messageData,
from somewhere. it has unique ids, for each record, and some other
attribute. Now we want to take the Unique Ids from MessageData, and put
a status saying "Recieve", so the target message will look like
<Records>
<Record ID="ID1" Status="Recieved"/>
<Record ID="ID2" Status="Recieved"/>
<Record ID="ID3" Status="Recieved"/>
</Records>

Now we post this data some where, and now we want to change the status
to say Posted. so the the target message should look like
<Records>
<Record ID="ID1" Status="Posted"/>
<Record ID="ID2" Status="Posted"/>
<Record ID="ID3" Status="Posted"/>
</Records>

Now there might be step# 3 as "Under Review" so the target message will
look like
<Records>
<Record ID="ID1" Status="Under Review"/>
<Record ID="ID2" Status="Under Review"/>
<Record ID="ID3" Status="Under Review"/>
</Records>

Now my question is for above should I create three maps or there is a
way I can cretae one and pass sort of parameter status.

Francisco A. Gonzalez wrote:
Hi Billa,

When you refer to messages, you mean orchestration messages, or intances
of
the same messages??

What does influence the value to set for status??
is it something stored in a database?
is something you want to set using a business rule?
you just want the value to be alternating on every change?, or maybe
choosed
randomly?

Depending of the case, we could help you on this.

Francisco A. Gonzalez
fgonzalez@xxxxxxxxxxxxxxxxxxxxxxxx



"Billa" <BillaTilla@xxxxxxxxx> wrote in message
news:1165428122.188929.24290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I want to put some dynamic values in a map. For example suppose there
are two messages, MessageA, and MessageB of both same type and one
atrribute say Status. for MessageA I want to set status ="Recieved",
and for MessagB I want to use Status="Approved"

Any help will be highly appreciated.



.

Relevant Pages

  • Re: Dynamic Values in a Map
    ... Now we want to take the Unique Ids from MessageData, ... so the target message will look like ... Francisco A. Gonzalez wrote: ...
    (microsoft.public.biztalk.server)
  • Re: SQL Adapter - Schema not getting generated
    ... "Francisco A. Gonzalez" wrote: ... I am using Biztalk 2006 and VS .Net 2005. ... The local computer may not have the necessary registry ...
    (microsoft.public.biztalk.general)
  • Re: SQL Adapter - Schema not getting generated
    ... "Francisco A. Gonzalez" wrote: ... I am using Biztalk 2006 and VS .Net 2005. ... The local computer may not have the necessary registry ...
    (microsoft.public.biztalk.general)
  • Re: export excel data to sql 2005 - Realtime
    ... I am not sure if there is a way to do it with the wizard, ... "Francisco A. Gonzalez" wrote: ... If you use an Excel source within an dataflow in ssis, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Adapter - Schema not getting generated
    ... "Francisco A. Gonzalez" wrote: ... The local computer may not have the necessary registry ...
    (microsoft.public.biztalk.general)
Loading