BUG: DTS Message Queue Task May Truncate Messages to 255 Characters (291307)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
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 "Data File Message."

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB291307
©2003 Microsoft Corporation. All rights reserved.