How to Drop an Excel sheet using SSIS RRS feed

  • Question

  • Hi all,

    I'm facing a problem with Excel Sheet,I use the "Execute SQL Task" to drop a sheet , the package could run successful,but the sheet still exists,but the data has been deleted,for this package, I could run this package any times.

    so please share your answer here .

    thank u all :)

    DROP TABLE 'Sheet_test13'

    Tuesday, November 14, 2017 8:52 AM


All replies