Why does the Excel Destination Plus Component ignore the new values entered into the editor?
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
Book a Presales Call
Related Articles
Why does the Excel Destination Plus Component ignore the new values entered into the editor?
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 Last Updated: 4/17/2024Why does the Excel Destination Plus Component ignore the new values entered into the editor?
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 Last Updated: 4/17/2024Why does the Excel Destination Plus Component ignore the new values entered into the editor?
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 Last Updated: 4/17/2024Can I use Data Flow Task Plus to write data into multiple worksheets in an Excel file?
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 ...How to configure the Excel Source Plus component to use particular worksheet when the sheet name is unknown?
If you are planning to use only the first worksheet in the Excel file, but the worksheet name is unknown then the steps below should be completed: 1) Make sure that you are using 2.0 version of COZYROC SSIS+ and up, because this feature to reference ...