I don't see much difference in performance. I have heard that OPENXML is faster, never used though. Do you think using OPENXML will be much faster? If so, how will I use OPENXML here?

With 31K records in the #output table it takes 40 mins.

Thanks for all your help.