The package configuration files exist in each environment. So for instance, if you are using configuration files on each servers, you would have 2 files, one on development with the connection string pointing to the development server / database. A second file would be on production, and that configuration file would have the connection string details for production.