You should look into SSIS configuration files. they are simple XML files. This way you can have prod and dev configurations that you substitute based on the environment where you are deploying the package. Works quite easily as simple XML parser capabilities can automate the process.