Thanks again everyone.  I'm working on, after hours at home, getting a home test bed stood up so I can muck around with this without actually doing it against "real" servers.

I was somewhat concerned about the possibility of the data load trying to start while one or more of the target servers was still truncating the target table, so the Sequence container (presuming it works as I'm thinking from your descriptions it should) will probably be the way to go.

As for constraints, etc on the target table, there are none, it's a stand-alone table, there aren't even any indexes (the data going in isn't very much.)  It's even possible duplicate data wouldn't be a problem for the customer for their purposes.