Thank you David.

I do not know nor really understand SSIS. I can't even spell SSIS <-- note red squiggly

As for manually writing transfer TSQL (or SSIS), that is what...

Jason - looking for some clarity before I can answer fully. So, when you say you are going to aggregate the data into a single repository, I'm assuming a single...