Why does my Excel Destination not overwrite the data correctly?

Why does my Excel Destination not overwrite the data correctly?

Problem:
When using the Excel Destination to Overwrite data, sometimes rows are written, but the existing data is not overwritten correctly.
Solution:
The property named "RetainSameConnection" on the Excel Connection needs to be set to "False".  This allows the connection during run time to recognize that the "Overwrite" has been specified in the Connection.

    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.