Update Table is not working in BODS through script
I have a problem updating SQL server 2008 table through BODS 4.2
My design as below
Script1: Here we are updating starttime before dataflow start. The below script is working fine for updating Startload.
SQL('DS_ODS','UPDATE Timestamp_Tables SET StartLoad = CURRENT_TIMESTAMP WHERE TableName = \'30DayOrderDemand\'');
Script2: Here we are updating endtime after dataflow completes. This is not working and its throwing error like incorrect syntax near '30' but its working for above script. Here only column name is different and both the cloumns are same datatypes Datetime.
SQL('DS_ODS','UPDATE Timestamp_Tables SET LastLoad = CURRENT_TIMESTAMP WHERE TableName = \'30DayOrderDemand\'');
Thanks & Regards,
Can you check if there's any trigger associated with table Timestamp_Tables?.
I think the UPDATE triggers something that causes the issue