Returning results to MSMQ from SSIS Package

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

JamieThomson at 2007-9-8 >