title: SSIS: The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons
body: <p>I have a variable in my SSIS package set to the following: </p>
  
  <pre><code>"Provider=Microsoft.ACE.OleDb.12.0;Data Source=C:\Users\CurrentUser\Dropbox\Eval\SynchDB.accdb;Persist Security Info=False;"
  </code></pre>
  
  <p>Then I have an OLE DB Connection in my connection manager and I set the Connection string property of that connection to my variable.</p>
  
  <p>I also created a data flow task with an OLE DB Source that is set to that connection, then I selected the table I needed, from the dropdown. But when I click on "Columns", I get an error: </p>
  
  <pre><code> "The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager"
  </code></pre>
  
  <p>Which does not make sense since my connection string is valid. Can anyone help me understand what is going on here?</p>