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
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Data Flow Task Plus editor doesn't open
Action: When I click twice on Data Flow Task Plus Component I get the following error: Error: Data Flow Task Plus' Editor doesn't open and instead of the I get the control flow tab. Solution: To solve the issue you should complete the steps below: ...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 ...Can 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 ...Where can I find the documentation for the Excel Destination?
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 ...Excel Destination: How to modify an Excel Destination start column dynamically at runtime
The destination start column is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired column number where you wish to begin writing in the Excel destination. ...