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+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: The ODBC Source.Outputs[ODBC Source Output].Columns[THUNK_COLUMN] has an invalid error or truncation row disposition.
Action: When executing a package using Data Flow Task Plus withing a Foreach Loop and an ODBC Source, the first iteration of the loop succeeds, followed by the following error message on the second iteration of the loop. Error Message: 'The ODBC ...Error Message: An error occurred with the following error message: Response reading timed out.
Action: When executing a command using the SSH Execute Task the following error message is received. Error Message: An error occurred with the following error message: Response reading timed out. Solution: Increase the timeout parameter in the SSH ...Where can I find the documentation for the ODBC Destination?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the ODBC Destination can be found at the following link. For many of the components you can find ...Error Message: The GuidRepresentation for the reader is CSharpLegacy, which requires the binary sub type to be UuidLegacy, not UuidStandard.
Action: While using the MongoDB Connection Manager, I received the following error message. Error Message: 'The GuidRepresentation for the reader is CSharpLegacy, which requires the binary sub type to be UuidLegacy, not UuidStandard.' Solution: In ...Error Message: "Failed to process ... for column COLUMN_NAME"
Action: The Salesforce object I am using has new columns and I am trying to add the new columns and map them to our destination table. When I execute the package I get the following error: Error Message: "Failed to process ...