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
Related Articles
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 ...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 ...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 ...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 ...How can I set the Date Format for dates in the Excel Destination?
Scenario: You have a package with an OLEDB Source and an Excel + Destination. In the source table you have a field that is timestamp [DT_DBTIMESTAMP] column which is getting converted incorrectly to a number like 43951.5869164352 when loaded to ...