How can I set the Date Format for dates in the Excel Destination?

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