Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Update Table is not working in BODS through script

Hi Experts,

I have a problem updating SQL server 2008 table through BODS 4.2

My design as below

Job--->Worflow--> Script1--->Dataflow--->Script2

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,

Balamurugan G

Former Member
Former Member replied

Can you check if there's any trigger associated with table Timestamp_Tables?.

sp_depends Timestamp_Tables

I think the UPDATE triggers something that causes the issue

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question