SSIS has an XML source and XML task. THe XML task can validate your data, merge it with another xml set and even do comparisons between the sets (You would set the operation type to "Diff" in this last case). Worth looking into if you have SSIS ( as I know this is a t-sql forum) and you dont have to to worry about lack if INTERSECT in sql server 2000.