what method do you use to run the package?  I use global variables to hold the details and set the connection first, if you run the package from dtsrun in a stored procedure you can pass the global settings in.