I'm using the SharePoint List adapter destination to write in a SP list from a SQL table. I have a datetime column with value expressed with date + hour + minutes.
I have two servers, the web server and the db server. On the db server I have installed the Adapters (SQL Server 2005 RTM): the Regional Settings is set to en-us
and the hour is set to AM/PM (but I think it is no matter). The web server that has the SharePoint content db are the same Regional settings (en-us + hour in AM/PM).
I'm using the same regional settings as site settings.
For a SQL datetime as 2010-03-19 10:00 PM, the adapter writes 2010-03-19 10:00 AM.
For writing in my list, in SSIS I must convert my SQL datetime in a DT_DATE: I have used a grid data viewer to observe the data passed before and after
the data conversion and before the writing and I can see the same datetime in the SQL table.
Any suggests to solve this issue, please? Many thanks