Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DTS and MSMQ
Message
De
14/01/2005 09:18:40
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
DTS and MSMQ
Divers
Thread ID:
00977178
Message ID:
00977178
Vues:
72
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.
Répondre
Fil
Voir

Click here to load this message in the networking platform