from xml data to sql server2005 threw SSIS

• dummy.sure

  Newbie

  Points: 1

  More actions

  August 21, 2008 at 6:34 am

  #123968

  hi

  i need data from xml to stored in SQl Server 2005 threw SSIS

  thanks

  surya

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 21, 2008 at 6:42 am

  #861182

  Can easily be done with a dataflow task, XML Source and a OLE DB Destination.

  It's pretty straight forward. See http://www.sqlis.com or http://blogs.conchango.com/jamiethomson/ for some tutorials.

  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!