Hi,

Well, XML is not thought for performance. If you are processing 7000+ rows and you want real performance, you should use CSV files or similar files with much less overhead. You can even gain performance by having a fast XML -> CSV parser first in your chain.

Otherwise, try other T-SQL XML parsing approaches (like with OPENXML or similar) to find out which one is faster.