An error occurred with the following error message: 0000-00-00 00:00:00 default is invalid for column type TYPE_TIMESTAMP.

An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP".

Action: 
When executing an SSIS package containing an ODBC Destination, the following error message occurred.

Error Message: 
An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP".

Solutions:
Please set a default value for the column, or do a NULL replacement for the input value in the data flow.

    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.