Microsoft KB Archive/291307

= BUG: DTS Message Queue Task May Truncate Messages to 255 Characters =

Article ID: 291307

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q291307



BUG #: 352516 (SHILOH_BUGS)



SYMPTOMS
A Data Transformation Services (DTS) Message Queue Task may truncate messages to 255 characters when it sends a message type of global variable and the global variable is assigned a string greater than 255 characters.



WORKAROUND
Instead of using a global variable message type in the Message Queue task, use an ActiveX Script task to write the contents of the global variable to a file. Then, in the Message Queue task, use the message type &quot;Data File Message.&quot;



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.

Keywords: kbbug kbpending KB291307

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.