Search code examples
sql-serverexcelssisetlssis-2012

SSIS: Truncate Excel Destination

I am creating a SSIS package that imporr data from a SQL Server Source to an Excel Destination.

How can one truncate spreadsheet before run? I tried the following way (using Execute SQL Task with no success.

enter image description here

Solution

  • Jet provider does not support neither truncate or delete command. You have 3 workarounds:

    • Have an empty excel template that you clone before the running the dataflow, or
    • Use execute sql task to create a new workbook/tab before running the dataflow
    • Drop the worksheet using Drop Table TableCall_Log and create a new one. You can referer to this Link for more details.

    Useful Links