SSIS: Output SQL to XML file

I wanted to create an XML file from an SQL table using SSIS. I found the following blog, but the method I used is in the user comments from “J. Morgan Smith”. I also had to do what “sam” and “BB88” said.

http://consultingblogs.emc.com/jamiethomson/archive/2006/07/11/4209.aspx

 

Advertisements