Ok, with that out of the way...
What i want to do is have data read from an MSMQ message (which will be a simple XML message) and have it transformed and inserted into a simple table. Sound simple, but i cant work out how to do it.
I started a new Integration Services Project and dropped a Data Flow task on the Control flow tab, then double-click it to go to the data flow tab. I have added a MSMQ connection manager which points at my private queue and i can hit the test button and it sees it tests ok. How do i wire that into my data flow?
On my dataflow tab i have a SQL Server Destination (set to the local SQl server instance) and ive been trying a DataReader source and try setting the Advanced Editor "Connection Manager" column on IDBConnection row to point to my MSMQ connection manager. I get some error "cannot aquire a managed connection from the run-time connection manager". How do i get a Data Flow source which reads the XML message off my MSMQ connection manager?
On the Control Flow tab you can add a Message Queue Task and i can bind it to my MSMQ connection manager and set it up as a recieve task etc, but how do i use that?
Help!
Well, like yourself I am a complete MSMQ bunny but nevertheless....
You are right that the MSMQ Task will be of help here. I don't know much about it but I am guessing that it allows you to save the message to a Variable. Am I correct? If so you can do that and then manipulate the data that is in the variable.
That is as much as I know. Like I say I don't have any experience of using MSMQ with SSIS.
-Jamie
|||Hi, yer, i think i can save the message data to a variable, but im a bit lost on which component ill need to transform that message - the XML one would seem the logical choice but i cant seem to bind it to that variable.|||
Hi
im new in msmQ TASK
I already configured the msmque task for sending. - > connected to dataflowtask -> msmque task for recieving is this the proper way to implement?
No comments:
Post a Comment