XML and SSIS help

• Nijojo

  Newbie

  Points: 3

  More actions

  September 21, 2008 at 10:15 pm

  #131375

  Hi,

  Please help. I have a database source table that has in one of its column XML data. However, looking at the data-type it is txt not xml!

  I would like to query the XML column, however I am not sure if I can if the datatype is XML.

  What can you suggest in SSIS? I am considering converting the xml column txt field to XML using SSIS. How can I do this?

  Is there an easier approach?

  Thanks.

  Nijojo

• Jack Corbett

  SSC Guru

  Points: 184397

  More actions

  September 22, 2008 at 7:55 am

  #874985

  Do you mean that the SSIS data type is text or the SQL data type is Text?

  Is the source SQL Server 2000 or 2005?

  You could use a Script Component to deal with the XML column.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question