title: How to delete data from excel sheet while creating and dropping table through SSIS package
body: <p>I have created a package that will query SQL server and return results to excel, this package should replace existing data on the excel with new data every time it runs.
  But Drop table command only clears the headings of excel table not the previous data.
  Its appending new data in sheet not deleting the old data.<img src="https://i.stack.imgur.com/BNZcN.jpg" alt="enter image description here"></p>
  
  <p>Drop table I am using this command. </p>
  
  <pre><code>  Drop Table `Report`
       Go
  </code></pre>
  
  <p>Create Table : </p>
  
  <pre><code>CREATE TABLE `Report` (
  `EmployeeID` Long,
  `EmpName` LongText,
  `EmpGrp` LongText
  )
  GO
  </code></pre>
  
  <p>Please help on this. How to delete data from table in excel.</p>