Are you assigning the Connection String to a Variable?
If not try creating a variable of string type to hold the Connection String. @[User::ConnectionString]
Change the property EvaluateAsExpression of @[User:::ConnectionString] variable to TRUE
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/