Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS.
Changing connections using a Dynamic Properties Task
DTS2000 introduced the popular, and very powerful, Dynamic Properties Task. This task enabled the package developer to make a DTS package what we term "location independant". This meant that we could take a package and run it on different environments simply by changing a value external to the package. That value could be stored in a number of places such as a registry entry or a good old ini file and would typically be the name of a server that a particular DTS Connection had to connect to.
In SSIS, the same can be accomplished using Configurations. The feature allows environment specific data to be stored in an external XML file. That XML file can be edited to suit the environment on which it resides. This blog contains a number of posts related to configurations including this post on indirect configurations