community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Out of range value

Highlighted
Meteor

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

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. 

Labels