locked
How to insert dynamic data into an XML or HTML format table RRS feed

  • Question

  • Hi there,

    I have a technical problem as the title described. I need to achieve this by SSIS that means the destination file could be XML or HTML. However, before inserting dynamic data from source, an XML or HTML format table must be predefined. In the final destination file, the predefined table and dynamic data will be both output.

    Can anybody give some suggestions or reference links regarding to this? Appreciate it.

    dbschenker

    • Moved by Darren GosbellMVP Wednesday, June 30, 2010 3:03 AM This is an SSIS Question (From:SQL Server Analysis Services)
    Tuesday, June 29, 2010 7:57 AM

All replies

  • Hi,

    You should try to use ScriptComponent with multiple outputs defined.

    One output for xml data, other fo html.

    Good luck.

    Alex.

     

    Tuesday, October 26, 2010 8:40 AM
  • You did not speak about the source that you use to generate the XML.

    In case the source is a table or some staging table you could use forXML query to generate the XML file and in the resultset set it to a string variable and use a script task to write this to a file and name it .xml.

    In case you want the output as HTML we need more details as how the final output looks like and source data.


    Sudeep's Domain   Tweet me..
    Tuesday, October 26, 2010 1:46 PM