How to drop and re-create excel sheet in SSIS

• hitesh.gowda86

  SSC Veteran

  Points: 217

  More actions

  September 1, 2015 at 9:13 pm

  #307382

  Hello Folks,

  I am splitting data from SQL table and sending it to excel file but everytime i rerun the package ,it appends the existing data in excel file ..I tried using execute sql task with excel connection and write drop table `tablename` and then one more execute sql task with create table `tablename` (`Id` int ,`fname` varchar(100)) ....But it does not seem to work ..Any help in resolving this issue ? ..Thanks

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  September 2, 2015 at 3:08 am

  #1823898

  Its been a while since I done this, but create your excel file from a excel template. This thread pretty much explains it all:

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c55a7763-630e-4fcf-9b70-b1fdab82d623/writing-ssis-package-to-load-data-in-new-excel-file-every-time-it-runs?forum=sqlintegrationservices

  MCITP SQL 2005, MCSA SQL 2012