.Net, MSMQ, and DTS -
10-05-2004
, 03:51 PM
Good afternoon everyone. I have a question that probably has a simple
answer, but I can't seem to find it anywhere on the Net.
I have a DTS Message Queue Task in SQL Server 2000. This task is invoked
via DTSRun command line utility, and has two global variables that are
updated when run. The data in the variables is then dumped to a message
queue in a single message.
I have a .Net windows service that monitors the queue. I get receive the
message with no problem, but I don't know how to extract the values from the
global variables. I don't even know what format the message is placed on the
queue with... is it an Xml Formatter or Binary Formatter? How can I get the
values from the messages?
Thanks everyone, I really appreciate the help. |