I have a similar situation and put together this solution, I think it might help you out. You would just need to modify the layout of the xml in my...

This seems to be a similar issue to what I was facing. My output files were anywhere from 50K to a couple of Mb so I wanted to be able...

Finally got it to work. What I had to do was put in the ContentType = 'text/xml'

[Microsoft.SqlServer.Server.SqlProcedure]

public static void PostXMLTransaction(string v_strURL, string...

UPDATE: After setting my Assembly to External Access from Safe, I now get the following error:

The objective is to send the results of a "FOR XML" query to a POX...

Thanks Flo,

Using almost the exact c# you provided, changing only the destination and sql connect and for xml query,

Here is what I am now getting as a response from SQL:

Msg...

try it this way:

SELECT

Col1, Col2, Col3

FROM PTable as property

--FOR XML PATH('property'), ROOT('properties'), type

FOR XML AUTO, TYPE, ELEMENTS, ROOT('properties'))