Post reply

Load XML File to table using SSIS

  • March 16, 2009 at 3:29 am

    #200967

    Hi,

    How to load XML data file to table using SSIS packages. Can you please provide a step by step process how to load xml data's into table ?

    Thanks,

    Balaji L

  • March 17, 2009 at 2:57 pm

    #961405

    Balaji (3/16/2009)

    Hi,

    How to load XML data file to table using SSIS packages. Can you please provide a step by step process how to load xml data's into table ?

    Thanks,

    Balaji L

    You have to setup data flow task. In it you have to create:

    1. XML Source component.

    2. OLEDB Destination to your database table.

    For more complex scenarios how to use XML Source check here.

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

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

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