如何从SQL Server导出到XML [英] How to export from SQL Server to XML

问题描述

从SQL Server [表或视图]导出为XML的最简单方法是什么?

What is the easiest way to export to XML from SQL Server [Table or view] to XML?

这是我到目前为止所做的

This is what I have done till now

执行Sql任务

SELECT * FROM Production.Product 
FOR XML AUTO, TYPE, ROOT('Data')

ResultSet XML

在左侧结果集部分中，我创建了新变量0 User :: XMLVal

in left result set section I have created new variable 0 User::XMLVal

脚本任务

 Dim sw As New IO.StreamWriter("D:\Apps\SSIS\test.xml")
    sw.Write(Dts.Variables("User::XMLVal").Value.ToString())


    sw.Dispose()

推荐答案

如果要使用任务组件，请设置Execute SQL Task以将SQL语句或存储过程的结果读取到用户定义的SSIS变量中.您上面的陈述是一个应像的好例子:

If you want to use the task components, set up an Execute SQL Task to read the result of a SQL statement or stored procedure into a user-defined SSIS variable. Your statement above is a good example of what it should look like:

然后使用XML Task将变量的内容写入文件:

Then use the XML Task to write the contents of the variable to a file:

这篇关于如何从SQL Server导出到XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！