There is a discussion item closed over a year ago that had same error, fixed apparantly by using en-us local in all cases.
In my case I am using OLE DB Source (from SQL) to SharePoint List Destination. 2 columns have [DT_DBTIMESTAMP] DataType. This produces error :
"[SharePoint List Destination] Error: Error on row ID="1": 0x8102001c - Invalid Date/Time value in the data being updated."
and 3 others that are the result of the first one...
Other discussions with topic of SharePoint via web services: how to pass a date? seem to indicate the format SharePoint wants is ("yyyy-MM-ddTHH:mm:ssZ").
Using a grid data viewer, the format I'm seeing is intirely different from either the format in SQL, or what SharePoint wants. Trying a data conversion in SSIS to [DT_DBDATE] is not only totally fruitless, the data format and contents is unchanged in the
data viewer output. For example the column Hire_Date is populted in the format "6/15/2009 12:00:00 AM", the data type converted column HireDate is identical even though the data type value is set to the aforementioned [DT_DBDATE].
So a little help here please, what can I do in SQL, or SSIS to make a SharePoint List not barf on recieving a datetime field?