Post reply

Delete sheet from excel file in SSIS

  • January 28, 2009 at 9:32 am

    #134085

    Hi

    I have a SSIS package that exports data to excel, it creates all the sheets ok, but because the source file cannot have no sheets, i am left with Sheet1 before my other sheets when the process finishes

    Is it possible to delete this sheet? i have tried drop table [Sheet1$] and it runs successfully but the sheet still exists.

    Thanks

  • January 28, 2009 at 1:32 pm

    #934133

    matt (1/28/2009)

    Hi

    I have a SSIS package that exports data to excel, it creates all the sheets ok, but because the source file cannot have no sheets, i am left with Sheet1 before my other sheets when the process finishes

    Is it possible to delete this sheet? i have tried drop table [Sheet1$] and it runs successfully but the sheet still exists.

    Thanks

    The "drop table [Sheet1$]" will not work. It is documented here. The only way to remove sheet is to implement a script, which uses Excel Automation API. However keep in mind you may have issues.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply