Load XML File to table using SSIS

• Balaji L

  Hall of Fame

  Points: 3067

  More actions

  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

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  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/