title: SSIS dynamic excel read
body: <p>I have been trying to read multiple excel files through SSIS from a shared location and i get two error messages.</p>
  
  <ol>
  <li>Error at FileLoopingTest [Connection manager "Excel Connection Manager"]: The connection string components cannot contain unquoted semicolons. If the value must contain a semicolon, enclose the entire value in quotes. This error occurs when values in the connection string contain unquoted semicolons, such as the InitialCatalog property.</li>
  </ol>
  
  <p><em>Expression:  "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+@[User::varFileName]+";Extended Properties=\"Excel 12.0 XML;HDR=YES\";"</em></p>
  
  <ol start="2">
  <li>The result of the expression ""Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+@[User::varFileName]+";Extended Properties=\"Excel 12.0 XML;HDR=YES\";"" on property "\Package.Connections[Excel Connection Manager].Properties[ExcelFilePath]" cannot be written to the property. The expression was evaluated, but cannot be set on the property.</li>
  </ol>
  
  <p>Any inputs would be great.</p>
  
  <p>Thanks</p>