Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags XML, 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,002 reads
   Items 1 to 1 of 1