Known issue - Pipeline activities don't save if their data warehouse connection is changed
In a pipeline, you can add a stored procedure or script activity that uses a data warehouse connection. If you change the data warehouse connection to point to a new data warehouse connection in the activity, you can't save the connection in the activity.
Status: Open
Product Experience: Data Factory
Symptoms
In the pipeline, the stored procedure or script activity changes doesn't persist after their data warehouse connection is updated.
Solutions and workarounds
Delete and recreate the stored procedure or script activity using the new data warehouse connection.