Has anyone in this group used "Message Queue Task" in SSIS? -- sql server dts

Thomas Hagen Johansen
7/4/2007 10:52:24 PM

I have previously posted two messages in this forum with questions about
the SSIS "Message Queue Task", which no one seems to know anything
about. For weeks I have searched the internet for samples and
documentation - with very little luck.

I have written an ASP.NET application which write messages to a MSMQ
queue. My plan is to have a SSIS package continuous empty the queue by
moving the messages to a MS-SQL table.

After a lot of frustration I archived this, but I feel I am bending the
idea behind the "Message Queue Task".

I am therefore considering to write a "Script task" which does the same,
and avoid using the "Message Queue Task".

Any comments on this?

Thank you very much in advance,

Darren Green
7/4/2007 10:57:03 PM

So a continuous process, or never ending package, is not really a great SSIS
usage pattern, but it is possible. The MQ task is a one message deal, so I
assume you have got it read messages from the queue, now wrap it in a loop
to keep it going. Does that help? What are you stuck on?

For SSIS you would be better asking in SSIS newsgroup
microsoft.public.sqlserver.integrationsvcs or the forum
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1

--
Darren Green
http://www.konesans.com | http://www.sqlis.com | http://wiki.sqlis.com

[quoted text, click to view]

Thomas Hagen Johansen
7/5/2007 12:00:00 AM

Darren - Thanks for answering!

I am not stock. I have setup with a "for loop" which never ends and
therefore keeps emptying the queue as you write. You indicate that this
is not really a great usage pattern - and I got the same feeling, so do
you have any other suggestions?

I experience two problems when running the package:

1. Sometimes the "Message Queue Task" fail with a missing handle to a
message it tries to receive.

2. I can't get the transaction support to work with the "Message Queue
Task" - please look at my previous post about this. This is critical
because I risk loosing messages.

Best Regards,
Thomas Hagen

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Has anyone in this group used "Message Queue Task" in SSIS?