Skip to main content

Hi,

I am using the ODX server to get data from the SQL server database.

After executing the transfer task, I am getting the below error.

Any idea how to solve this?

“System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.”

Which version of ODX and SQL Provider are you using ?

Have you defined incremental load on a date type column ?

Can you use a Query Table with an explicit SQL statement to extract rows from this table ?

Hi @sguntupalli, another alternative is to use data type override feature to bring in the date column as text and then later on convert it back to a date

 

Hi @sguntupalli did you manage to resolve the error? If so can you please help us by selecting and marking a best answer

Reply


Terms and ConditionsCookie settings