Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Creating an SSIS package to generate an XML output file Expand / Collapse
Author
Message
Posted Thursday, April 17, 2014 10:31 AM This worked for the OP Answer marked as solution


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 9, 2015 12:22 AM
Points: 170, Visits: 400
@TS : see this... http://www.codeproject.com/Articles/635956/How-to-export-data-from-database-tables-to-an-XML

Good Luck :) .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Post #1562760
Posted Thursday, April 17, 2014 12:36 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 19, 2016 8:27 AM
Points: 50, Visits: 142
a4apple thanks for the link.

I needed to add select (...) as COL_XML that did the trick.

Thanks everyone for your help.
Post #1562817
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse