title: ssis 2008, delete contents from excel
body: <p>im using SSIS for SQL Server 2008.</p>
  
  <p>My SSIS package grabs data from sql and exports it to an excel file. But everytime it does this I want new data on the excel.</p>
  
  <p>The problem right now is, If i execute the package more than one time I will have the old data plus the new one on the excel file. I only want the new data displayed.</p>
  
  <p>On the SSIS, on the Control Flow tab I have an Data Flow task. On the Data Flow tab I have an OLEDB source and an Excel Destination in order to put the data on the excel.</p>
  
  <p>So im thinking on deleting the contents from the excel on the SSIS every time before the data gets inserted on the excel.</p>
  
  <p>The excel file has an image, a title and the column names. I want these data to stay. </p>
  
  <p>But I want the data from the rows deleted.</p>
  
  <p>How can I do this?</p>
  
  <p>Thanks...</p>