Post reply

Description for creating an xml file as output

  • October 10, 2011 at 3:51 am

    #390575

    Hello all,

    I need to create an xml file output from data in my 2008R2 database, ideally automated by a daily job. However, I have struggled to find a scalable solution. Using SSIS to write FOR XML statement to a variable, and then write variable to a file was the best i could do.

    Time is getting scarce now, and I need a solution. Can anyone (please) point me in a direction for any software that can do this automatically?

    If I am barking up the wrong tree, then that advice would be appreciated too!

    Thanks

    A

  • October 10, 2011 at 9:51 am

    #1392485

    I think you could go a few ways with this. One would be to create a sql plan that would write the query for you then use the FOR XML AUTO (or RAW can't remember). The other would be to use some script like vb or powershell that would pull the data and use windows schedule tasks.

    Here is a good resource for XML and using vbscript. SQLXML 4.0 Programming Concepts

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

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