I am trying to insert data in the format of yyyy-MM-dd HH:mm:ss into SQL Server 2000. If I am running the adapter service directly, it is inserting the date. On sql server field is defined as timestamp.
But in the flow if I am trying to insert, it is giving me an exception :
Cannot set data for the input field “CHECK_DATE”
Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
I tested by trimming the field after conversion also, but still not working. Can anyone please help me.
Thanks & Regards,