dbTalk Databases Forums  

Posting an XML formates message to MSMQ in a DTS

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


Discuss Posting an XML formates message to MSMQ in a DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michiel van Buuren
 
Posts: n/a

Default Posting an XML formates message to MSMQ in a DTS - 02-20-2006 , 03:47 AM






Hi

I want to post put messages on a MSMQ based on information in a database on
a regular base. The set up is to use as scudeled DTS package to perform this
task. The message format is XML. I have tried to use the select ... for XML
but only get a binary string back.

Has anybody done this?
Is it posible to get the XML string directly for a query?

Michiel



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.