how to activate a stored procedure to create a receive message

Home Page Forums BizTalk 2004 – BizTalk 2010 how to activate a stored procedure to create a receive message

Viewing 1 reply thread
  • Author
    Posts
    • #24806

      This is my second BizTalk project.  This project should

      step1: receive a flat file and insert/update a table in SQL server A

      step2: revoke a stored procedure in another SQL server B to get a set of data in xml format using “for xml auto”

      step3: use the xml data from step 2 to update the table in step 1

      This is what I have done:

      1. create projectSchema 1 to create schemaFlatFile, schemaInsert, pipeline, map needed for step 1
      2. create projectSchema 2 to create schemaReceiveUpdateData,schemaSendUpdateData, map needed for step 2 and 3
      3. create projectOrchestration:it includes 4 messages: messageFlatFile, messageInsert, messageReceiveUpdate, messageSendUpdate. 4 ports: PortReceiveFlatFile, PortSendInsert, PortReceiveUpdate, PortSendUpdate.

      I know something is wrong with messageReceiveUpdate.  I get different error when select True or False for Activate.  I don’t know how it should be done to invoke the ReceiveUpdateData stored procedure to create the messageReceiveUpdate.

      Your help will be highly appreciated.

      Lynn

    • #24824

      Did you solve this one?  It looks like you have another post much like this one (SQL related) that you posted after this one.

      • #24826

        My question was actually wrong since I didn’t know for selecting query I should use request respond port.  But thanks for reply and yes I have passed that issue.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.