MSMQ

Does anyone know or have any idea what's the use of msmq or how can this apply in ssis.

Thanks

Find out what MQ is-

Message Queuing (MSMQ)
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msmq/html/ff917e87-05d5-478f-9430-0f560675ece1.asp)

Find out about the MQ task you have in SSIS-

Message Queue Task
(http://msdn2.microsoft.com/en-us/library/ae1d8fad-6649-4e93-b589-14a32d07da33.aspx)

|||

Do you have a requirement to use MSMQ, or are you just curious about it? If you're just curious about it then google both terms and do some research.

If you have specific questions about either MSMQ or the MSMQ task in SSIS ask them here, and I will try my best to answer them for you.

|||

can you help me how am i going to use this the "MSMQ task in SSIS"? thanks

Sean Schade wrote:

Do you have a requirement to use MSMQ, or are you just curious about it? If you're just curious about it then google both terms and do some research.

If you have specific questions about either MSMQ or the MSMQ task in SSIS ask them here, and I will try my best to answer them for you.

|||

Can you help us and explain what you are trying to achieve? The task is there, documented, and does what it says on the tin. Do you want to send a message? Do you want to recieve a message?

Have you read any of the references or do you have any specific questions?

Do you know how to create a SSIS package?

Can you add a task to a package? (Hint - Drag and drop from the toolbox)

Now open the the task, and fill in the details required. What could be simpler?

How you use it in the context of a wider application or process is an impossible question on its own as we have no idea what you need to do!

|||

Hi All,

I am going to build an application that is transaction sensitive with asp.net, C# and SQL Server. There will be a folder which will have the text files and I am writing a windows service that picks up these text files and inserts them into SQL Server database. In case, if the SQL Server is down I should not lose any transactions and based on what I read I am thinking that MSMQ is the option wherein I can queue the transactions and insert them into the database once the SQL server is up and running.

Please suggest if this is correct approach or if there is any other alternatvie.

Thanks,

Thanvi