I am trying to load excel sheet to sql server2005. I converted data types of excel souce to corresponding type of OLEDB Destination.But still I am getting errors.
I enclosed excel sheet ,SSIS Package and sql for creating table.Can any one Try it.
Change the Package extension from 'txt' to 'dtsx' and open SSIS Package
I got the following errors
[Data Conversion ] Error: Data conversion failed while converting column "Preferred_Status" (56) to column "Copy of Preferred_Status" (363). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[OLE DB Destination ] Error: There was an error with input column "Phase_Out_Date" (1830) on input "OLE DB Destination Input" (1787). The column status returned was: "The value could not be converted because of a potential loss of data.".
Thanks and Regards,