We have a table in our old Sql Server 2000 database that has a nText data type field the we store and xml formatted string. We are now moving to Sql Server 2008 and I want to convert this field to an XML data type. When I attempt to just do a conversion, I find that some of the data is not well formed. I am thinking SSIS would be the best tool to do an import from the old table to the new one. I see examples of validating XML when importing a file but not from another table. How would I validate the data being imported before doing the import and also get a report of all the records that failed the import? Thanks Royal

you can use script component and .NET script to validate xml column data, this is sample .NET code to validate an xml: http://support.microsoft.com/kb/307379/EN-US/http://www.rad.pasfu.com