title: SSIS and MySQL - Table Name Delimiter Issue
body: <p>I am trying to insert rows into a MySQL database from an Access database using SQL Server 2008 SSIS.</p>
  
  <pre><code>TITLE: Microsoft SQL Server Management Studio
  ------------------------------
  
  ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-community-nt]You have 
  an error in your SQL syntax; check the manual that corresponds to your MySQL 
  server version for the right syntax to use near '"orders"' at line 1
  </code></pre>
  
  <p>The problem is with the delimiters. I am using the 5.1 ODBC driver, and I can connect to MySql and select a table from the ADO.Net destination data source. 
  The MySql tables all show up delimited with double-quotes in the SSIS package editor:</p>
  
  <pre><code>"shipto addresses"
  </code></pre>
  
  <p>Removing the double quotes from the "Use a table or view" text box on the ADO.NET Destination Editor or replacing them with something else does not work if there is a space in the table name.
  When SSIS puts the Insert query together, it retains the double quotes and adds single quotes. </p>
  
  <p>The error above is shown when I click on "Preview" in the editor, and a similar error is thrown when I run the package (albeit then from the actual insert statement).</p>
  
  <p>I don't seem to have control over this behavior. Any suggestions? Other package types where I can hand-code the SQL don't have this problem.</p>