Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Wednesday, May 7, 2014 10:09 AM
Points: 141, Visits: 313
@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
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 8:14 AM
Points: 49, Visits: 122
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