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.