Post reply

SSIS Package

  • January 2, 2007 at 7:02 am

    #115670

    Hi Guys,

    I have an SSIS package that has a SQL statement that produces different data everyday. In the SSIS package the data is being transferred right into an Excel spreadsheet. Because the data is different everyday, the excel spreadsheet must be overwritten and the new data must be placed in the same spreadsheet. At the moment the data is just be added onto the existing spreadsheet and the old data is not being truncated.

    Can anyone pls explain to me how I would overwrite the data in the Excel spreadsheet?

     

    Kind Regards

    Imke

  • January 3, 2007 at 6:21 am

    #680943

    Hi,

    I'm pretty sure you can't delete data from an excel spreadsheet using OLEBD. However a simple way to do this would be to have an empty copy of the spreadsheet which you use to overwrite the target spreadsheet everytime the package runs.

    Regards

    Daniel.

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

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