Hi, I have request Q, where many apps are dumping messages. Is it possible ti read message, check some values and then discard if it is not relevant to my app? This does involve reading more than one messages from MSMQ. Any examples/Approach suggestion would be very helpful I can read one message from MSMQ but it gets complicated if I want to read more than one and different kid of messages. Past few days, I have been reading this forum and boy I learned so much which would have been much more time and money consuming process without this forum. Thanks

Hello NewToReporting, glad to hear this forum is so helpful. How about you execute your package every so often? Or you can create a For loop Arthur My Blog

you can use script task to fetch data from MSMQ with .net code, this is sample of working with MSMQ from .net: http://www.eggheadcafe.com/tutorials/aspnet/af86b2ae-f9b9-4f29-a08b-9332ed9da498/c-msmq--send-and-receive-xml.aspxhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com

yes, I need to use for loop. The part I am not clear about is reading each message and selecing and discarding them How to do that part.....

Reading MSMQ messages using SSIS: http://blogs.msdn.com/b/martijnh/archive/2010/06/10/reading-msmq-from-within-ssis-packages.aspx Arthur My Blog