Forum Discussion
ramankr48
Helper II
Helper IIGetting error or issue while updating the column in log table in datawarehouse
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, ...
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!!
NandanHegde
Super User
Super Useryou need to update the script activity and use a single = rather than ==
where pipelinerunid =
ramankr48I had tried this earlier also, it was not working, gave some error