- This topic has 1 reply, 1 voice, and was last updated 8 years, 9 months ago by
.
-
Posts
-
-
Hi,
for our application the vendors send data in various excel formats, these excel formats are converted to xml using a pipeline component.
to implement time-order the Excel files need to be dumped to a Queuing mechanism.The files range in size from 400kB to 100MB.How do you push Excel files to the MSMQ to be picked up by BizTalk?
since the files are not in XML and will only be converted to XML once picked up by BizTalk.
Can MSMQ support greater than 4MB file sizes ?I have heard about MSMQT ,MSMQC and WCF-MSMQ, which is apt for use with Biztalk 2006 R2 in this scenario?
The flow needs to be something like this
[Excel] -> .NET Application -> MSMQ -> BizTalk
thanks,
Jerry -
Hi Jerry,
You would push the Excel files to MSMQ for BizTalk just like you push any file to MSMQ (using System.Messaging or WCF). WCF-MSMQ is the way to go if you are using R2. The core transport is still MSMQ, you just use WCF to read and write to the queue. MSMQ does have a hard size limit. 4MB sounds about right. It sounds like you won’t come close to that limit, but if you do there are a couple of options. You could write code to chunk the files, send them to the queue, and then reassemble them on the other side. Alternatively, you could drop MSMQ altogether. The BizTalk message box itself behaves like a queue, so in many cases you don’t need MSMQ if you are using BizTalk. For example, you could set up a 2 node BizTalk group with a WCF http receive location on both servers and put them behind a load balancer. Now you have a highly available, load balanced channel into BizTalk. You can send a message into BizTalk via WCF, and it is automatically queued up in the message box.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.