Summary: In ADF pipeline, using lookup to select all the data and passing each row at a time to ForEach Activity. Inside ForEach activity, first I have copy data activity where I read value from lookup and pass as source and sink and load data. Next I was to run a stored procedure. Repeat this process till all lookup has been completed.

SELECT [SchemaName]
      ,[TableName]
      ,[SourceFilePath]
      ,[StoredProcedure_1]
  FROM [dbo].[ADF_ControlTable]


@item().SchemaName
@item().TableName
@item().SourceFilePath
@item().StoredProcedure_1

Copy Data activity using source and sink with @item() value, I am loading data from file to table. (This works as intended)

Next step I want to execute script activity within foreach and execute @item().StoredProcedure_1

This is showing user configuration issue. most declare scalar variable “@item”