SSIS and XML

• mhuff 77104

  Newbie

  Points: 1

  More actions

  September 21, 2011 at 2:55 pm

  #257770

  I have a text field in a database table that is stored in XML format. The frontend web application can take that XML and put it into usable product. I am trying to extact pieces of information from that 'XML Document' via SSIS. I only need about 5 fields from that XML text, but need it to be automated and able to be put into SSIS package.

  Please help.

• okbangas

  SSChampion

  Points: 11773

  More actions

  September 21, 2011 at 3:14 pm

  #1384841

  One solution would be to do it in SQL instead: Cast it to the xml data type and the use the xml methods (nodes/value etc).

  XML Support in SQL Server 2005

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]