[OLE DB Destination] Error in SSIS:

[OLE DB Destination [9]] Error: There was an error with input column
SYSTEM_DATE_TIME (130) on input "OLE DB Destination Input" (22). The column status returned was: "The
Value could not be converted because of a potential loss of data."
Resolution:
Check any invalid date value in source csv file, if yes then, change it to 01\01\1753.(Or try to change the
 Invalid date value to valid date value).

That’s all.

Comments

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)