In SSIS when we will execute a Transfer Master Stored Procedures Task. There is option IfObjectExists, if we will choose Overwrite option
We may get warning message like:
Overwriting Stored Procedure "" at destination
It is only warning that SSIS package is overwriting the existing stored procedure. So don't worry about this.