I am getting the following error while executing a SSIS package.
[OLE DB Destination ] Error: There was an error with input column "RecordEffectiveDate" (828) on input "OLE DB Destination Input" (773).
ÃÂ The column status returned was: "Conversion failed because the data value overflowed the specified type.".
Source is a non sql server with datetime datatype and the data like 10/20/2004 2:23:27 PM
and the sql server destination datatype is datetime.
View Complete Post