title: Syntax error in 'drop table' or 'drop index' in ssis package
body: <p>I am deleting and recreating excel file using ssis. I used ExecuteSQLTask and write sqlstatement </p>
  
  <pre><code>drop table 'Employee'
  go
  CREATE TABLE `Employee` (
  `BusinessEntityID` INT,
  `JobTitle` NVARCHAR(50),
  `BirthDate` DATE,
  `MaritalStatus` NVARCHAR(1),
  `Gender` NVARCHAR(1),
  `HireDate` DATE
  )
  </code></pre>
  
  <p>but when i am executing the package then i am getting the following error :</p>
  
  <blockquote>
    <p>[Execute SQL Task] Error: Executing the query "drop table 'Employee'
    " failed with the following error: "Syntax error in DROP TABLE or DROP INDEX.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.</p>
  </blockquote>
  
  <p>Please help me to fix it.</p>