I agree with Steve to not save passwords in SSIS. Modify your SSIS package to set them with variables. Here are some links with explanations on how to do this:

I don't know if it will work, but I would give the "copy database" wizard from SSMS a try (right-click a database...tasks...copy database). If that don't work you can still...

Below is a solution without looping. Although I guess this is still not the most optimal way... it's the best I could come up with for now.

[code...

Take a look at scenario 2 as written in this article. With this scenario you create a new [master] database after which you can replace it with the...

Pinal Dave described such an issue several years back. See https://blog.sqlauthority.com/2015/04/10/sql-server-login-failed-for-user-reason-server-is-in-script-upgrade-mode/. Can you check the SQL Error log (from Windows Explorer/Notepad)?

@steve-2: Agree, but the original query filters on one year. That makes my suggestion valid for this query. It may not be the case when different specs are...

Which one to use depends on your needs. But reading your post I guess a UNION fits well.
The position depends on the process. You can first join all...

Do you have a "MERGE", "MERGE JOIN" or "UNION" task in the Data Flow? You'll need to combine the derived output of each file into a single set before writing...

Have you tried just removing the database from the AG and next take it out of restoring state by setting it to recovery?

ALTER DATABASE database_name SET HADR OFF