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:
- create projectSchema 1 to create schemaFlatFile, schemaInsert, pipeline, map needed for step 1
- create projectSchema 2 to create schemaReceiveUpdateData,schemaSendUpdateData, map needed for step 2 and 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