Returning results to MSMQ from SSIS Package

I want my package to return the results to the MSMQ queue. from where it will be picked by another application. How do we do that.

Do u suggest using service broker for that. in that case how to connect that application to ssis service broker?Any Idea Experts?|||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.|||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|||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|||

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