XML as destination

• Smash125

  Hall of Fame

  Points: 3562

  More actions

  July 13, 2011 at 11:56 pm

  #145788

  Can XML file can be used as destination?

  Is there any other way i can do it

  -Praveen

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  July 14, 2011 at 2:34 am

  #1352622

  There isn't an out of the box XML destination in SSIS.

  There are probably some 3rd party components out there, either paying or open-source.

  Or you can create your own using a script component.

  Take a look at the following site:

  http://agilebi.com/jwelch/2007/06/02/xml-destination-script-component/

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP