none
Ignoring qotations in schema ?? RRS feed

  • Question

  • I have data coming in as qotations, how can I ignore the qotations in BizTalk schema ?

    My sql table column has 9 charecters, but the qotations is making that to come upto 11 charecters.

    How can I fix this?

    "0007197522"||"N"|"E"||"N"|"0005419197"||"N"|"11177EP0000001"||"N"|"50"|||"20161001"|||"99991231"||"N"|"ZN82270D"||"N/A"|||"N/A"|"ACTIVE"||"N"|".00"|".00"|"N/A"|".00"|".00"|"N/A"|"416.53"|".00"|"N"|".00"|".00"|"N/A"|".00"|".00"|"N/A"|".00"|".00"|"N/A"|"416.53"|".00"|"N"|"630190802"||"N/A"|||"N/A"|"113434265"||"N/A"|"36061"||"N/A"


    MBH

    Friday, December 2, 2016 6:44 PM

Answers

  • In the properties of element in the schema changing

    Wrap Character Type - Character

    Wrap Character - "

    This fixed my issue. Thanks solved by myself


    MBH

    • Marked as answer by JaguarsJag Friday, December 2, 2016 7:53 PM
    Friday, December 2, 2016 7:53 PM