dbTalk Databases Forums  

Help with Message Queue Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Help with Message Queue Task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Kerrison
 
Posts: n/a

Default Help with Message Queue Task - 02-03-2004 , 08:22 AM






I want to create a DTS package that will use a Message Queue Task to
read messages from a Queue and then insert these messages into a SQL
Table.

How can this be done?

thanks

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Help with Message Queue Task - 02-03-2004 , 08:27 AM






Have a look at this

http://www.ftponline.com/conferences...19CHSQLDTS.pdf

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Chris Kerrison" <chris (AT) ckerrison (DOT) freeserve.co.uk> wrote

Quote:
I want to create a DTS package that will use a Message Queue Task to
read messages from a Queue and then insert these messages into a SQL
Table.

How can this be done?

thanks



Reply With Quote
  #3  
Old   
Chris Kerrison
 
Posts: n/a

Default Re: Help with Message Queue Task - 02-04-2004 , 05:12 AM



thanks for that But any ideas how to process "String Messages" created
from a c# application. The DTS package can read these items but I
need to know how to process/import into a DB table.


thanks







"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:
Have a look at this

http://www.ftponline.com/conferences...19CHSQLDTS.pdf

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Chris Kerrison" <chris (AT) ckerrison (DOT) freeserve.co.uk> wrote in message
news:af16557c.0402030622.64f992c7 (AT) posting (DOT) google.com...
I want to create a DTS package that will use a Message Queue Task to
read messages from a Queue and then insert these messages into a SQL
Table.

How can this be done?

thanks

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.