As shown in Figure Syncronize Task is sucessfully completed, but Transfer Task gets an below error
“System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 ”PM even though my date range starts from 2002 and ends at 2023.
Even though after suggestion by
“System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out”
(This error is geeting for those tables who has Date Column, and date column has such data (for example 03/01/2022 6:42 PM ) )
What are steps to solve above error?
Solved
Date Range Error
Best answer by Karankadam
Hi
+5Hi
It is a timeout, have you tried to increase that? If so did it fail still and if so before the allowed time was exceeded?
+5Hi
Hi
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
