Did you properly shut down the operating system before having the primary drive replaced?  If so, SQL Server would have shut itself down and there shouldn't be any problems.  If...

You'd be far better served using SQL 2012 Developer Edition than SQL 2012 Express.   Express has too many limitations.   I strongly suspect that SQL 2008 is having problems dealing with...

Okay, so how did you tell PowerShell to look in that directory?

Do you have a Calendar Table available?   That would be ideal, but lacking same, how would you define your weeks?   Either way, however, if you insist on dividing a month...

Turns out the package tries to run PowerShell, only to discover that the file 'AzureUsers.ps1' doesn't exist in the location it was expecting to find it.   So the portion of...

Like Luis said, what are...

The problem is that the account under which the job runs has no "screen" to present the message to.  Not sure what Windows does with that, or SSIS for that...

Okay, so it hangs... is there a wait condition or blocking going on, perhaps caused by index maintenance, backups, or ETL activity?   Check with your DBA...

Hate to be a bad news delivery agent, but if these are financial records, and you're voiding them out, I have to wonder why?   What if you were subject to...

When you say "executes find during all times except Monday morning.", what actually happens on Monday morning?  Does it fail?   Does it just not finish?  How is it being executed? ...