Hi @ClarissaJacquline ,
Welcome to Microsoft Q&A platform and thanks for posting your question.
As I understand, you want to know how to handle metadata changes in an ADF pipeline, where the source is Salesforce and the target is SQL Server, without manual intervention.
You can achieve this using the MetaData-driven copy task, as explained here. When there's a need to add new fields or make any other metadata changes, simply edit the control table. Updating the control table will generate a new SQL script for you. Just rerun the SQL script to update your control table.
I found this video to be very helpful in explaining the process.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click
Accept Answer and
Yes for was this answer helpful. And, if you have any further query do let us know.