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 ...
Problem: When I change the row values in Excel Destination Plus Editor the new values get ignored. Please look at the screenshot below: Solution: To fix this issue you need to change the Setting Retain Same Connection to False
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 ...
Yes, you can use DFT+ with Excel Destination Plus to write data into multiple worksheets in an Excel File. To accomplish this, you will need to use variables and an expression to provide the sheet names to the package. For a demonstration showing how ...
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Excel Destination can be found at the following link. For many of the components you can find ...