Man this is one ugly POS, probably written by a VB programmer.

Yes, it can be re-written to be set based and it would run light years faster. To be honest though, doing this sort of thing is what I like to get paid for, and right now I'm pretty busy on multiple projects and don't have a lot of time to do extra work for free.

Maybe someone with some extra time will chime in. Remember though. this is largely a forum providing advice, tips and short solutions to specific issues, not redesigning bad ETL processes. The people that post here do it voluntarily as their time permits.