Post reply

SSIS Package to Export SQL Server 2005 table to XML file

  • January 5, 2009 at 10:02 am

    #155086

    Hi,

    Does any one know how to create SSIS Package to Export SQL Server 2005 table to XML file? I tried the Export and it does not have any destination option for XML file. Also, I tried BIDS application to create SSIS package and it does not have any Destination to XML file.

    Thanks in advance.

    SK

  • January 5, 2009 at 11:57 am

    #921344

    sinha929 (1/5/2009)

    Hi,

    Does any one know how to create SSIS Package to Export SQL Server 2005 table to XML file? I tried the Export and it does not have any destination option for XML file. Also, I tried BIDS application to create SSIS package and it does not have any Destination to XML file.

    Thanks in advance.

    SK

    There is adapter available from third-party. You can check it here.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 10, 2009 at 9:12 pm

    #924939

    I was not interested in any third party programs. I have gotten some complicated code to write SSIS package. I will try that later. I was interested in creating directly an SSIS package that transfers SQL Server 2005 table to an XML file that can be retrieved into another program. There is a way to transfer to text file but not XML file.

    SK

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

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