Creating XML from SQL Server 2005 - What are my options?

  • Awesome responses. Thanks a lot.

    By the way, I am not very familiar to Powershell and would like to stick to SSIS to generate XML file and to store it in file system.

    Could you please let me know what tasks i should be using as i am a beginner to SSIS?

    Should i use "Execute SQL task" to run the query that generates XML file and use "File System Task" to save the file in file system?

    Thanks again in advance.

    Regards,

    Suresh

    Regards,
    Suresh Arumugam

  • Please start a new thread, Suresh. It's considered impolite to hijack a thread with questions that have little to do with the original subject. Especially older threads like this one.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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