Todd,

Can see why you've come to that conclusion and does seem the best way
to implement it by the looks of things so I may use that method in the
future.
SSIS though is a fickle thing and for some strange reason (that still
bemuses me) is that is seemed to lose the connection string every 5
minutes during one day with me until I figured out about saving them
in the config file and then setting it as read only. This was only
during test runs in BIDS though as I never got as far as a roll-out to
a DB instance at that point.

Axel - the bit about not updating is not when using BIDs to execute
the package - build and deploy it to a SQL instance and when setting
it to run you manually edit the connection strings in there. That's
the method Todd suggested; and when you think of it the most secure
unless you hand out your sa details to everyone!

All good eitherway; 2 more ways around the mess that is SSIS. As a
note; I'm a SQL guy as well - and BIDS is pretty much a bent nail in
terms of implementing SQL if there ever was one; especially after I've
finished with it! )
Hope that helps you though Axel.

Scho

p.s.
Todd - nice blog I've saved that for later ;o)