Post reply

Sample XML File to Import to SQL

  • September 26, 2012 at 8:37 am

    #282118

    Hi all

    Where can I get a sample XML file to test importing to SQL via SSIS.

    Thanks in advance.

  • September 26, 2012 at 1:18 pm

    #1542594

    You could make your own. If you run this against any instance in your environment it will return an XML document that you can then save as a file for use experimenting with SSIS.

    SELECT *

    FROM master.sys.tables AS

    FOR XML AUTO,

    ROOT('tables');

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • September 27, 2012 at 4:53 am

    #1542787

    Thanks I'll give it a go.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply