Post reply

How do I export an XML file via SSIS package?

  • July 28, 2008 at 10:18 am

    #849281

    Just about to leave work so a quick reply.

    Try running the select statement in a SQL task, and save the result as XML to a variable.

    Then, use an XML task to write out the variable to a file. Not sure how it will deal with such a large file, but it should work in theory...

    plus, you can transform it with XSL if necessary.

    anyone else with other thoughts?

    Tom

    Life: it twists and turns like a twisty turny thing

  • July 28, 2008 at 2:28 pm

    #849437

    Thanks for the reply Tom.

    I tried your suggestion, but was unable to process it without getting errors. I wasn't sure whether I needed to do an xslt, xpath, diff, merge, etc... I tried a few but kept getting errors.

    I eventually came accross the following ways that suggest running the sql statement into a variable and then writing the variable out to a file via a script:

    http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/05/22/21084.aspx#27317

    http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx

    I used the first one and it worked well. Thanks again...

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

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