Post reply

XML Export to individual files

  • March 18, 2014 at 9:40 am

    #289433

    Looking for an article that takes data from an XML column in a table and exports each field as a separate document.

    Separate articles for each technique (SSIS, PoSh, etc).

  • July 7, 2014 at 7:23 am

    #1727348

    Hello,

    I was able to come up with a SSIS package that reads an XML column into a recordset and then uses s script component to output the data for each record into it's own XML file. Is this what you were looking for? I can go ahead and submit the article, just wanted to check if this is what you had in mind when writing this suggestion.

    Thanks,

    Camille

  • July 30, 2014 at 9:07 am

    #1733660

    Submitted an article that goes over the steps to do something similar to this.

  • July 30, 2014 at 1:57 pm

    #1733794

    Thanks, I'll take a look as soon as I can.

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy