Post reply

Export SSIS data into Xml Spreadsheet 2003 file

  • July 4, 2010 at 4:57 pm

    #222888

    Hi,

    I am very new to SSIS.I would like to know how data from SSIS is exported into a xml file.The difficulty part over here is XML file is saved from EXCEl 2007 as XML SpreadSheet 2003 format.

    I would appreciate 3 rd party control suggestions too.

    Thanks,

    Adi

  • July 4, 2010 at 5:18 pm

    #1188649

    I don't know about the XML spreadsheet, but you can use the Export data wizard to export to an Excel 2003 format. You can write a query to put data out in an XML format. As far as a specific format for XML spreadsheet, I'm not sure, but you can script anything with SSIS with some programming.

  • July 8, 2010 at 3:23 pm

    #1190524

    Someone has put together the script needed to have an XML destination from SSIS.

    http://tinyurl.com/33lnkg

    The instructor for a SS 2008 class pointed this out.

    Steve

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

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