Hi.. I am new to Biztalk and to this forum. I need some suggestion. My requirment is I need to read some MSMQ messages from 10 different servers [ like Order ], read that message [in xml format] parse and put that into one SQL server database for analysis purpose. I know I can do this very easily with simple .NET code that reads all the data from MSMQ, parse it and push that into a SQL server. But I want to do it using Biztalk since we already have a set up for that.
So my question is can it be done using Biztalk and is it a good way of doing it ? BTW I followed samples and I am able write an Orchestration that will read messages. But when I try to parse that data I am getting an error like below
“The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure. ”
Thanks for help