Dear friends,
Today I’ll add to the community a new type of post, a StepByStep post, based on the support that I usually provide to users from MSDN Forums and Experts-Exchange… some real examples and real scenarios from real world. I'm trying to purpose the best solution but could have several other solutions based on your feedback and suggestions… this is the goal of this community... share knowledge…

Scenario

After being created several packages for an ETL project, it became necessary to allow them to be copied between multiple environments (development, production and quality) with the greatest possible autonomy.

Purposed solution

One possible solution is to use the XML functionality available in SSIS package configuration, which allows the configuration (server name / Database name) of the main database be stored in a XML file. You need to modify this file only once in each environment and you should store in the file system of each environment
(Ex: c:\MyProjectName.dtsconfig)

Read the entire StepByStep example in the attached document below.

Reference: SSIS_EX_01_PCKCFG