Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-20 : 07:32:25
|
| sundar writes "iam pumping a xml into the msmq using a webservice and from the msmq i would like to use the dts for fetching the xml document in the queue and then use open xml to process the xml and dump it into a table. Issue 1: Though receive queue is successful, iam not able to pass the value to the stored proc with open xml query for parsing the received xml string. Can any one provide me with a sample or code snippet.Issue 2: I would like to use a msmq trigger for triggering the dts package to do the above task instead of having a windows service waiting indefinitely for the queue to fill up." |
|
|
|
|
|
Issue in using msmq task dts to feed sql stored proc openxml