Trouble with expected datetime format in SharePoint destination

[Torben N Heidi Edliq]

I'm attempting to insert events in a SharePoint 2013 Calendar list. I've observed the source data type to be DB_TIMESTAMP with the output being similar to "2014-11-09T19:30:00". What data type is SharePoint expecting for the fields "Start Time" and "End Time" in the Calendar list? 

I can't get the date-time formatting to take, and have continued to receive 

[SharePoint Destination [177]] Error: An error occurred with the following error message: "
(1) Invalid column value in the data being updated.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "SharePoint Destination" (177) failed with error code 0xC02090F9 while processing input "SharePoint Destination Input" (184). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.

I've tried DT_DBTIMESTAMP2,DT_DBTIMESTAMPOFFSET, DT_DBTIME, DT_DBTIME2, nothing is working.

Appreciate the help as always!

[Ivan Peev]

Hi Torben,

Have you tried: DT_DBTIMESTAMP

?