DATE CONVERSIONS
STRING 2 DATE SourceFormat Example yyyy.mm.dd SELECT convert(datetime, ‘2021.03.30’, 102) dd.mm.yyyy SELECT convert(datetime, ‘30.03.2021’, 104)
Cast
The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value.
The Column DateTimeOffSet allows date within range 0001-01-01 through 9999-12-31. This causes the problem. Try the
REQUESTED CAST IS NOT SUPPORTED
SSIS kann nur Datenkonvertierungen zwischen bestimmten Daten-Typen machen, sonst kommt es zur Feldermeldung “Cannot cast
