- This topic has 4 replies, 1 voice, and was last updated 7 years, 3 months ago by
.
-
Posts
-
-
Hi Guys,
Please can any one help the task:
Task:
I have a xml schema in that schema having 10 fields,in those fields one field called ” To”‘
i created the table in sqlserver the table is email_T with schema fields.
My Question is: how to trasfer the emailids to “To” field in sql server table and email id should be comma separated values…..
Please help Asap……….
Regards,
Raja.
-
Hi Raja,
In a BizTalk map, draw a link from each of the 10 fields in your source schema to a String Concatenate Functoid as input parameters, and add 9 additional parameters to that functoid, each specifying the comma character, making sure to alternate your field parameter with the comma parameter, in the following order:
FieldParameter1
CommaParameter1
FieldParameter2
CommaParameter2
…
FieldParameter9
CommaParameter9
FieldParameter10
Then, in the same map, draw a link from the String Concatenate Functoid as output parameter to the "To" field in your destination schema, representing your SQL table.
Good luck.
-
-
You need the additional parameter that contains the comma character, because that's what you would use to separate your email address values, and those email addresses don't have that character. So, you would alternate that comma parameter with each of your address fields when concatenating them together in the string concatenate functoid, before sending this as a whole to your destination field.
-
-
-
-
- The forum ‘BizTalk 2013 & BizTalk 2013 R2’ is closed to new topics and replies.