none
Biztalk WCF-SQLCalling a SP RRS feed

  • Question

  • Hi ,

    I have a situation where I have to consume a stored procedure(Req -Resp) in biz talk application.But the same SP is already consumed in the other Biztalk application ,from which we can't take the reference or do any kind of modification.

    I have consumed the SP from the new Biztalk application but i am facing the problem while application is running it is throwing error of multiple schema found as the auto generated SP schema have the same namespaces like(xmlns="http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo) .

    Is there any other approach other than providing the document namespace in the pipeline??

    Friday, July 15, 2016 3:58 PM

Answers

  • It's very, very simple.  All you have to do is:

    1. Create custom Pipelines with the XmlDisassembler/XmlAssembler.
    2. In the Document Schemas Property, select local (to the app) copy of the Stored Procedure Schema.
    3. Deploy the Pipeline and set you custom Pipelines on the Ports.

    That is the solution.

    Friday, July 15, 2016 4:42 PM
    Moderator

All replies

  • HI,

    is it a duplicate thread???

    as same thread is going on right now in the community.

    Refer to the thread...

    This

    You will have to do certain modifications.


    Mandar Dharmadhikari


    Friday, July 15, 2016 4:04 PM
    Moderator
  • It's very, very simple.  All you have to do is:

    1. Create custom Pipelines with the XmlDisassembler/XmlAssembler.
    2. In the Document Schemas Property, select local (to the app) copy of the Stored Procedure Schema.
    3. Deploy the Pipeline and set you custom Pipelines on the Ports.

    That is the solution.

    Friday, July 15, 2016 4:42 PM
    Moderator