title: SSIS Double Backslash is causing connection issues
body: <p>I'm currently using an Execute SQL Task to pull in dynamic information to build my connection string for each of my databases.  From there I'm passing them to a Foreach Loop.  At this point I'm building my connection string using an expression:</p>
  
  <p>"Data Source="+ @[User::DatabaseServer]+ "\\"+@[User::Instance]+";User ID="+@[User::UserName]+ ";Password="+ @[User::Password] +";Initial Catalog=Defaul;Provider=SQLNCLI10.1;"</p>
  
  <p>My issue is the following, when my connection string is built with a double backslash.</p>
  
  <p>Data Source=DatabaseServer\\InstanceName;User ID=UserName;Password=Password;Initial Catalog=Default;Provider=SQLNCLI10.1;</p>
  
  <p>Does anyone know how to prevent the double backslash from occurring?  I've tried to use the escape characters but I have had 0 success.</p>