locked
export from sql server to xml file RRS feed

  • Question

  • Is there a way to export data in xml file from sql server table using SSIS?
    SandyLeo
    Thursday, October 28, 2010 10:00 PM

Answers

  • Just to confirm, you want to export XML data stored in a table to a file, right?

    If yes, you can do this in Execute SQL Task

    SELECT * FROM MyTable FOR XML AUTO

    and pass that to a Flat File Connection

     


    Arthur My Blog
    By: TwitterButtons.com
    Friday, October 29, 2010 12:24 AM