SSIS - Format issue in sending message through MSMQ task

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  April 11, 2013 at 5:44 am

  #292090

  Hi,

  I am trying to send some messages to a public MSMQ through the SSIS package using MSMQ task.

  I want to send several message through the package and want to map the body of the message from a SSIS variable.

  When I send the message by hard coding it in the StringMessage attribute on the Send tab of MSMQ it works fine. The message is received in the correct format at the queue.

  But when I try to use Expression and map the MessageString propety to my variable (defined as string) the message is received in a unusual format (I think it is treated an array of bytes , please see attachments)

  The variable is defined as string in the package. And if I check using the break point it get the correct value assigned to it.

  Attached are the screenshote of the MSMQ task. and of the messages received at the queue.

  I am not sure whats going wrong when I am trying to send message by mapping from a variable and hard coded messages works.

  -Vikas Bindra