Monolog conversations in SQL Service Broker 2008

Posted by hemil on Stack Overflow See other posts from Stack Overflow or by hemil
Published on 2010-05-12T01:10:20Z Indexed on 2010/05/12 1:14 UTC
Read the original article Hit count: 328

Filed under:
|
|
|
|

Hi,

I have a scenario in which I need to process(in SQL Server) messages being delivered as .xml files in a folder in real time.

I started investigating SQL Service Broker for my queuing needs. Basically, I want the Service Broker to pick up my .xml files and place them in a queue as they arrive in the folder. But, SQL Service Broker does not support "Monolog" conversations, at least not in the current version. It supports only a dialog between an initiator and a target service.

I can use MSMQ but then I will have two things to maintain - the .Net Code for file processing in MSMQ and the SQL Server T-SQL stored procs. What options do I have left?

Thanks.

© Stack Overflow or respective owner

Related posts about sql

Related posts about service