none
how to override the excel destination data using ssis?

    Question

  • I created  a package which runs everydays and dumps the data into an excel file.

    The problem iam facing is that -today the package runs and fills in the excel file,tomorrow it again runs and fills in the data without deleting the previous records.......

    But i want it to delete the records already present and fill in the excel

    Step 3: Drop Table

    second stup am using excute sql task to create the same excel sheet,

    But am getting the same result ,Table is not deleted and not created in the second stup

    can some one pls find the problem and resolve as earliest

    The external columns for comp

    onent "Excel Destination" (28

    ) are out of synchronization with the data source columns. The external column "SERV_LOCATION_ST" needs to be updated

    i GOT THIS WARNING FINALLY ........

    • Edited by Ychinnari Saturday, July 27, 2013 10:16 AM
    Saturday, July 27, 2013 6:55 AM

Answers