How to Overwrite an Excel sheet using SSIS or How to Delete data Before Inserting into Excel Sheet RRS feed

  • Question

  • Hi all,

    i facing a problem with Excel Sheet, when i running SSIS package at that time it appending the data to already existing data .but i want to overwrite the data or delete the data and reinsert the data into excel sheet.

    and i tried Drop table Excelsheet; and agian using another execute sql task creating Excelsheet but it not working :( .

    so please share your answer here .

    thank u all :) 

    Friday, August 3, 2012 12:01 PM


All replies