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 excel. Attempts to convert the column value in the SQL query as well as using a data conversion or derived column in the SSIS data flow do not convert it to the desired format. (Example: YYYY/MM/DD HH:MM)
Solution:
Go to the page http://www.cozyroc.com/ssis/excel-connection.Scroll down to find the parameter "Date Format".You can use this parameter to specify the date format for the Excel File.
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
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 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 FalseExcel 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. ...Excel Destination: How to modify the Excel Destination worksheet name dynamically at runtime
The destination worksheet name 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 name of the destination worksheet. Right-click on data flow canvas and ...