topic Re: Getting error or issue while updating the column in log table in datawarehouse in Pipelines

Getting error or issue while updating the column in log table in datawarehouse

ramankr48 — Thu, 17 Apr 2025 14:19:48 GMT

Hi Team,

I have deigned a pipeline where iam running store procedure then updating the pipeline status into the table using script activity, but it's not changing, I have tried different method, check below the sc

In this method script activity throwing error saying {Incorrect syntax near '='.}

also tried with this method, creating a parameter at scrpt level

but status is same as default not changing even when sp getting successfully executed

Re: Getting error or issue while updating the column in log table in datawarehouse

NandanHegde — Thu, 17 Apr 2025 16:52:56 GMT

you need to update the script activity and use a single = rather than ==

where pipelinerunid =

Re: Getting error or issue while updating the column in log table in datawarehouse

v-sathmakuri — Fri, 18 Apr 2025 07:38:38 GMT

Hi ramankr48 ,

Thank you for reaching out to Microsoft Fabric Community.

please use the below script in the expression builder to update the Pipeline_Metadata_Log table with success status for the current run id.

@{concat('UPDATE Pipeline_Metadata_Log SET Status = ''Success'' WHERE PipelineRunId= ''', pipeline().RunId, '''')}

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thank you!!

Re: Getting error or issue while updating the column in log table in datawarehouse

NandanHegde — Fri, 18 Apr 2025 07:41:56 GMT

This can be done without the concat as well as stated below wherein replace == with =

Re: Getting error or issue while updating the column in log table in datawarehouse

ramankr48 — Mon, 21 Apr 2025 06:45:26 GMT

I had tried this earlier also, it was not working, gave some error

Re: Getting error or issue while updating the column in log table in datawarehouse

ramankr48 — Mon, 21 Apr 2025 07:01:09 GMT

Hi v-sathmakuri

the solution you provided it worked, but the same update statement I have tried in adf it worked there but it's not working in fabric,
1. what is the reason??

2. so do we need to pass the sql statements in script like this always