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.