Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS and MSMQ
Message
From
14/01/2005 09:18:40
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
DTS and MSMQ
Miscellaneous
Thread ID:
00977178
Message ID:
00977178
Views:
73
I have created an ActiveX package in DTS written in JavaScript that is set a as a scheduled job from SQL Agent.

In the Agent I enter a message to pass to the DTS Package.
in xml format
((Tag characters have been omitted so I could save this message.))
publish pctr=''

In Sql Agent I enter a command line executes DTSRun and passes the parameter to the ActiveX script.

The ActiveX script accesses the MSMQ API and sends the message to a Queue.

All of the above works.

Here is the problem. The message arrives in UTF16. C# .Net code accesses the message queue and attempts to read the message. The C# code fails to load the XML. Even if I go back to the original text and add ?xml version='1.0' encoding='UTF-16' ? The C#.Net code does not read the message from the queue.

All other messages sent placed in the queue and subsequently read from the queue do not require the XML declaration.

Finally, here is my question. Using the technique above, (or some other SQL Server implementation) how do I get the message to arrive in the queue in UTF-8 format.
Terry Rooks
Software Systems Architect
Microsoft Certified Solution Developer.Net

If at first you don't succeed, then skydiving definitely isn't for you.
Reply
Map
View

Click here to load this message in the networking platform