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
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: "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 ...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 ...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: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error CS2008: No inputs specified"
Action: When running an SSIS package under the SQL Job Agent, the following error is encountered. Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error ...