Hi there

I am extracting data from an Access database into SQL
Server tables, and then I want to send this data directly
to a MS BizTalk Server Message Queue Receive Function
without going via flat file. I am adding a Message Queue
Task in the DTS-Designer, but the helpfiles are no help in
getting this done...

How do I set this up, has anyone done anything similar?
Doesn't have to include BizTalk, as long as you have done
the message queue part.

Regards
TrJ

In article <096001c366f0$3e6841b0$a501280a (AT) phx (DOT) gbl>, TrJ
<terjesandersen (AT) hotmail (DOT) com> writes
There is no way to stream data into the Message Queue task. I'm not sure
if this would even be possible if you where to write your own component.

I think a file would be simplest and allow you to use the existing task.

Alternatively can't BizTalk talk to SQL? You could put a message on a
queue to trigger biz talk into waking up and firing a schedule, but then
query SQL directly to get the data s instructed by the original message.
It's been a while since I've used BizTalk so I may have lost the plot
here.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com