Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create an actual disk file from SQL 2008 in xml form

Status
Not open for further replies.

CarolCook

IS-IT--Management
Mar 7, 2003
158
US
Hi:
I have no problem generating a SQL2008 query with results in XML. What I don't know how to do is how to get it to create a file on disk so that I can import into an unrelated application in it's UI.
Any help is appreciated.
Thanks
 
If you've full service including ssis, bring the question to the dedicated forum:
Any thing less, you can try lower-end solutions basically use [1] sp_cmdshell with bcp, or [2] bcp in command line prompt, or [3] write some wps script... In any case, it may not be as straightforward as one may anticipate as some configurations are not default to allowing it. you have to pass the question to mssql forums, starting from the above as it is not even remotely related to this forum.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top