in your SSIS Data Flow, one of the available Transformations is called Derived Column.  Put that task between the source and destination tasks.  Here's an article describing in more detail...

You could do this in a Derived Column transformation, with an expression such as:
REPLACE([ColumnName], "-duck", "- duck")

you can specify the schema name of the original object in the @objname parameter, you just cannot specify a schema name in the @newname parameter.
EXEC sp_renane @objname...

sp_rename only renames the object itself, you can't change the schema it is in, so when you specify the @newname, don't put the schema name in that.  The documentation explicitly...

It is the preferred way to do it, keeping the PK and FK enabled.  What problem were you having?

A good place to start with general troubleshooting may be looking at the database waits:
https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
this can give you a general feel for what's the biggest problem in...

I'm thinking there's something wrong in this script... when I run it against one of my development databases on a table with 6 indexes, it only shows 2 of them,...

Databases don't really have a "version" as you've described it, you can find the version of the instance you are connected to like this:
SELECT

If you just need a week number within a year, the DATEPART function can handle that, but if you really need to figure out weeks by month, it might make...

I store my SSIS passwords in a third party password manager, along with the rest of my database related credentials for service accounts and any SQL authenticated logins.  I keep...