Re: Email Ids not coming in sqlserver Table ,It should be comma separated values…..

Home Page › Forums › BizTalk 2013 & BizTalk 2013 R2 › Email Ids not coming in sqlserver Table ,It should be comma separated values….. › Re: Email Ids not coming in sqlserver Table ,It should be comma separated values…..

August 21, 2014 at 8:35 PM #28023
community-content

    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.