SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Integration Services (SSIS), export data Rss

   Items 1 to 1 of 1   

Export to XML Using SSIS

Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.  Read more...
By Additional Articles 2013/06/27 | Source: SQL Server Performance | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 3,738 reads
   Items 1 to 1 of 1