Returning results to MSMQ from SSIS Package

Returning results to MSMQ from SSIS Package

• EdZilla

  Tim Daniels wrote:

  Well this is confusing me also. Suppose I have a simple flat file, I want to process the file and send each row as a separate message to an MSMQ queue for consumption elsewhere. How do I do that Feels like it should be a MSMQ destination in the dataflow, not an MSMQ task in the control flow; something here I am not understanding. Thanks Tim

  
  
  Tim,
  Read the data into a variable using the Recordset destination. Loop over that variable using a Foreach loop container, each time passing the resultant row values into some locally scoped variables. Inside the Foreach loop container have an MSMQ task to put the row onto the queue.
  
  It sounds like an MSMQ destination may be a viable request. You could write one yourself, perhaps using the script component.
  
  -Jamie
  
  
  

• awparran

  Well this is confusing me also. Suppose I have a simple flat file, I want to process the file and send each row as a separate message to an MSMQ queue for consumption elsewhere. How do I do that Feels like it should be a MSMQ destination in the dataflow, not an MSMQ task in the control flow; something here I am not understanding.
  Thanks
  Tim
  

• theartful_dodger

  Any Idea Experts
  

• iamreal2

  MSMQ task should be able to take care of this.
  
  As far as I'm aware the new T-SQL extensions are the method of interfacing with SQL Service Broker. In which case they can be issued using the Execute SQL Task.
  
  -Jamie
  
  
  

• Lau Kok Soon

  Does the MSMQ task not do what you want
  It's hard to answer a vague question like this.
  Results from what What form are the results in
  Where do you expect to use the results in the future
  Usually, the quality of the answer you get here is directly correlated to the quality of the question.
  
  
• Returning results to MSMQ from SSIS Package