Home Forums SQL Server 2005 SQL Server 2005 Integration Services Overwrite data in excel using SSIS RE: Overwrite data in excel using SSIS

  • April 2, 2009 at 9:10 am

    #970812

    Princess (4/1/2009)

    Hi,

    I have creted a package that gets data from a table and adds it to a excel worksheet. The problem is everytime I run the packge it appends to the worksheet instead of overwriting the data in the worksheet, is it possible to overwrite the data in the same worksheet?

    Thanks in advance.

    Hi ,

    I am not sure if SSIS offers any option to overwrite the existing file for EXCEL. I have gone across to a good article and it may help you:

    http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9c21b7ee-5737-469d-8b96-62e0cad41616/

    Thanks,

    \\K

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂