Post reply

Excel destination overwritten data regularly

  • November 5, 2007 at 1:44 am

    #118712

    Hi i am new to ssis

    i created one package for loading data from oledb to excel file.

    i want to put it in job schedule which runs regularly.i want to over write the data every time.i worked a lot but i didnt find the solution.

    please suggest me or give me related links

    thanks

    srini.

  • November 5, 2007 at 6:14 am

    #748201

    I have the same problem.

    Thank you if you can help us.

  • November 6, 2007 at 4:40 am

    #748586

    Let Excel pull the data instead. Create your Excel workbook using external data, and set the Data Range Properties to Refresh data on file open. (Give your user select access to the source query on SQL Server.)

  • November 7, 2007 at 7:27 am

    #749097

    Make two excel file, one is template.xls and another is say destination.xls. Before transfer the data from oledb to destination.xls. Copy the template.xls to destination.xls by File system task

    then transfer record from data flow system

    Let me know if you need more detail

    Thanks

  • November 7, 2007 at 8:40 am

    #749126

    Thank u for your solution.

    🙂

    If someone know another method that overwrite the file each time the package is execute...

Viewing 5 posts - 1 through 4 (of 4 total)

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