Sending XML result set to MSMQ queue

Last Post 01 Aug 2008 04:45 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Xanthos1969
New Member
New Member

--
30 Jul 2008 06:14 AM
I need to send a XML resultset of "Excecute SQL Task" to a MSMQ.

When I save the result set in a variable and send it using a "Message Queue Task" the message gets 2 additional tags (ROOT and STRING) How to avoid these extra tags.
SQLUSA
New Member
New Member

--
01 Aug 2008 04:45 AM
Probably, the best thing to do is to remove them at destination.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/


Acceptable Use Policy
---