Post reply

Generate XML using SSIS

  • October 14, 2012 at 11:01 am

    #151104

    Can someboy tell me is it possible to generate XML using SSIS script task and SSIS variables (not from SQL table but if not possible then ...)???

    The xml which is supposed to be build has multiple nodes. eg. Parent Node->Child Node->Child Node.

    I have to use SSIS variables, During Runtime the variables will be populated will data and this has to added in the xml..Any help will be highly appreciated.

    thanks,

    Sa.M

  • October 15, 2012 at 7:15 am

    #1549123

    Hi,

    We can generate XML files using for xml clauses in SQLServer.

    Step 1: use For xml to get data into XML format.

    Step 2: Assign XML data to a object variable using Execute SQL Task.

    Step 3: Use a script task to generate XML file using object variable content.

    Please refer to below link.

    http://www.simple-talk.com/sql/learn-sql-server/the-xml-methods-in-sql-server/

    Thanks,

    Sambasiva

  • October 18, 2012 at 1:05 am

    #1550310

    what about using SQL to generate the file. Use SSIS to call the procedure.

    ?

    Ian Cockcroft
    MCITP BI Specialist

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

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