Ah ha! I knew there had to be a way!

So have the SQL job set the varibale value for the pkgs to use and

simply have a script component read the variable and set the connection

string proprties for the connections. Sounds workable.

I'm going to give this a whirl.

And, I believe it will also solve the 2nd issue as well.

Thanks very much!