I'm wondering the same thing as Gordon. As is often the case, it seems that there are multiple ways of accomplishing the goal.

Quote from SQL Server 2005 Books Online:

Connection Manager How-to Topics (SSIS)

The properties of connection managers such as the connection string must frequently be updated at run time. To learn more about dynamically updating properties, see Package Configurations and Using Property Expressions in Packages.