hey,

I am misunderstanding your posting slightly...

Assuming you have created an environment variable which tells SSIS where your package configurations reside, and assuming that within these package configurations (if I am correct they reside in SQL) you have specified your connection strings, your package should not be failing.

What authentication are you using when connecting to your OLEDB sources (windows or SQL?). If it is SQL, you will have to make sure that you specify the userid and password as part of your connectionstring, if it is windows authentication, there may be problems with your SQL server agent account (rights).

~PD