Lab02 execute adf pipeline failed

[maadityo]

i did validate and running storeproc failed from ADF, but success from SSMS. :(

hereby my store proc value.
thanks

[kromerm]

Can you copy and paste the full text from your value field here in a reply? Including @joshuha ...

[JihongL]

@joshuha @kromerm

I have same issue.
Leave error message below.

{
"errorCode": "2400",
"message": "Parse error at line: 1, column: 75: Incorrect syntax near '@return_value'.",
"failureType": "UserError",
"target": "Execute SQL"
}

And full text I input to value field.

DECLARE @return_value INT, @exe_id BIGINT, @err_msg NVARCHAR(150) EXEC @return_value=[SSISDB].[catalog].[create_execution] @folder_name=N'ADFLab', @project_name=N'ADFLab', @package_name=N'Module2.dtsx', @use32bitruntime=0, @runinscaleout=1, @useanyworker=1, @execution_id=@exe_id OUTPUT EXEC [SSISDB].[catalog].[set_execution_parameter_value] @exe_id, @object_type=50, @parameter_name=N'SYNCHRONIZED', @parameter_value=1 EXEC [SSISDB].[catalog].[start_execution] @execution_id=@exe_id, @retry_count=0 IF(SELECT [status] FROM [SSISDB].[catalog].[executions] WHERE execution_id=@exe_id)<>7 BEGIN SET @err_msg=N'Your package execution did not succeed for execution ID: ' + CAST(@exe_id AS NVARCHAR(20)) RAISERROR(@err_msg,15,1) END