The issue has been pinpointed a little better. Setup is still the same as in the original post but it only seems to be locking up the DB account...

They are in this package. The import/export wizard would work but not for how we're trying to set things up.

I think what's happening is the connection manager is trying...

Would the RetainSameConnection Property in the connection manager be what I'm looking for? So it only makes the connection once and not 20 times?

First off thanks for the reply!!!

I've got my Dimension Tables setup and in the Database and I understand how to load the keys into the fact table. My issue...