Hello Daniel,

You'll need to add a DataConversion Task between the Source and Destination Components. This conversion task will then take the excel's output column as input and define the specified format.
Sometimes this does not work and you'll also have to define a script and convert the values 'manually'.

Hope this helps

>Hi All,
>
>I am creating a SSIS package to import data from an Excel spreadsheet into SQL Server 2005 and received the following error message when trying to add DT_DATE field type from Excel into datetime field in SQL.
>
>I used the Data Conversion component to convert the DT_DATE to DT_DBTIMESTAMP as suggested in many articles that I found but it did not help and still I am getting the following error:
>
>Error: 0xC020901C at Data Flow Task, Excel Source [5366]: There was an error with output column "SHIP DATE" (11465) on output "Excel Source Output" (5374). The column status returned was: "The value could not be converted because of a potential loss of data.".
>
>Thank you,
>Daniel