dbTalk Databases Forums  

.Net, MSMQ, and DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss .Net, MSMQ, and DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Szabo
 
Posts: n/a

Default .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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.