Reg: XML Source

• Senthilkumar-456461

  SSC-Addicted

  Points: 491

  More actions

  July 16, 2007 at 7:12 am

  #117713

  Hi,

    How to extract data from xmlfile using the xmlsource.

  please help --- tell me the steps.

   

  by

  Senthil

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  July 17, 2007 at 2:32 am

  #719923

  Step one: Create Data Flow

  Step two: Drop XML Source component.

  Step Three: Select XML file.

  Step four: Click Create XSD

  Step five: Read BOL Examples.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!