Hi Daniel,

Just a thought - what will happen if you would save your Excel file as CSV first?

>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