IS package failed with converting a date field

[manmaria]

[SQL Server Destination [52]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E07 Description: "Error converting data type DBTYPE_DBTIMESTAMP to datetime2.".


I do not have any datetime2 data types. All I have is datetime datatypes.

Any Help Pl.

 

[ousoonerjoe]

Have you verified that the data is not 'out of bounds' for a DATETIME data type? IE: 25:60 is not a valid time; 13/1/20009 is not a valid date.

Also, you may need to make sure you are using valid date formats for your system. (IE: MM/DD/YYYY versus DD/MM/YYYY).

--------------------------------------------------
Bluto: What? Over? Did you say "over"? Nothing is over until we decide it is! Was it over when the Germans bombed Pearl Harbor? No!
Otter: Germans?
Boon: Forget it, he's rolling.
--------------------------------------------------