title: Incorrect Syntax near '-' .(Microsoft SQL Server Native Client 10.0)
body: <p>While doing SSIS job I got an error in my create table query</p>
  
  <blockquote>
    <p>Incorrect Syntax near '-' .(Microsoft SQL Server Native Client 10.0)</p>
  </blockquote>
  
  <p>SQL statement:</p>
  
  <pre><code>CREATE TABLE Staging_ACD_Precision_Queue 
  (
      PrecisionQueueID int,
      BucketIntervalID int,
      EnterpriseName varchar(32),
      AgentOrdering int,
      CallOrdering int,
      Description varchar(255),
      ServiceLevelThreshold int,
      ServiceLevelType smallint,
      ForceExpandingQueue varchar(1),
      Deleted varchar(1),
      ChangeStamp int,
      Partner varchar(4),
      Center varchar(4),
      Partner-Center varchar(9),
      LOB varchar(4),
      Circle varchar(4),
      TypeOfBusiness varchar(4)
  )
  </code></pre>
  
  <p>I tried the above query. I guess from the error message that, the issue is in <code>Partner-Center varchar(9)</code> but I failed to fix this error. Since I'm new to SSIS and SQL queries I don't know to fix the issue.</p>
  
  <p><img src="https://i.stack.imgur.com/8TQkY.png" alt="enter image description here"></p>