>The issue here is that the archive database is multi-tenant. The databases being archived are single-tenant - therefore, when I'm archiving I don't know my source. As you can see, I also have joins going across databases and to make matters even worse I won't even know the BatchTableName or Database until archive time.
Very interesting. I think it's the first time I learned about single-tenant / multi-tenant.
I found this article
http://msdn.microsoft.com/en-us/library/aa479086.aspx, will check it later.
If it's not broken, fix it until it is.
My Blog