Home Forums Data Warehousing Integration Services CAST VARCHAR date to datetime at load RE: CAST VARCHAR date to datetime at load
michal.lisinski
SSCertifiable
Points: 6933
More actions
September 2, 2015 at 12:53 pm
#1824120
Hi
Please check
1. The locale settings for the server, typically happens if you passed date as MM/DD/YYYY and should be DD/MM/YYYY (or vice versa).
2. Nvarchar values are less than 1753-01-01 or/and greater than 9999-12-31.
Best regards
Mike