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+.

• Related Articles

• 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 ...

• 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 ...

• How to dynamically set the ExcelFilePath when looping through different excel files in a data flow.

  Scenario: I have many Excel files with a same format to convert to text files, and I have created a ForEach Loop to loop through each Excel file to have a data flow with an excel source to flat file.   Question: How can I dynamically set the ...

• 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

• 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. ...