Post reply

Load XML files

  • April 12, 2008 at 11:09 am

    #185320

    I want to load the xml data files to sqlserver 2005 database.

    Please suggest..

  • April 12, 2008 at 5:29 pm

    #801836

    To load a single XML file drag a Data Flow Task onto the Control Flow canvas. On the Data Flow canvas add an XML Source and a destination.

    If have multiple files that share a common XML definition then you could add a Foreach Loop Container on the Control Flow canvas and place the Data Flow Task into that.

    References:

    Real World Foreach Loop Container example[/url]

    JumpstartTV: SSIS videos

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

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