SSIS Snack: Name Those Connections!

Today I have learned from an SSIS article that we should name the 'Application Name' property when creating a connection on Connection Managers.

Here is the link to refer: http://sqlblog.com/blogs/andy_leonard/archive/2012/02/09/ssis-snack-name-those-connections.aspx

But my project is a little different. We assign the connection string to an SSIS string variable and on runtime, this will map to OLEDB Connection by expression.