Hello @johannah Motshwene ,
Thanks for the ask and using the Microsoft Q&A platform .
Since you are using the foreach loop , I am assuming that the you are copying once table at a time . I am assuming that you are getting this error when you try to copy bigger tables . Can you please check this ? ( create a copy activity and select a table name which is big and try to run it .
I think increasing the timeout setting in the copy activity should help .
Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members