I'm beginning to think I had two problems.

One, I didn't understand the process well enough, nor did our admin staff who got all the documentation together......

Two, there were serious communication issues with our ETL.

I'm sure all will turn out well. Login to read more.