Out of range value

Question

Hi ,

I`m push a data from a table to another table.

However,

It gives me an error as below

"Tool #6 DataWrap2ODBC::SendBatch: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated.[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated. Insert into"

What could be the reason of this error and how to solve it?

Thank You

mkosmicki1 · Answer

@jdunkerley79 any idea how to resolve this? I do not have a way to change this as I am pulling data from the client's server.

jdunkerley79 · Answer

The error seems to be:

The conversion of a datetime2 data type to a datetime data

At a guess the target table has a datetime based column. In SQL Server, these can only hold 1753-9999 as a year. I would expect you have some dates coming out which are before 1753.