You should also look at the logs (both windows and SQL) to see if there is any more information about the error.  If it is a permission denied on the...

I've seen that error when it was unable to delete the previous backup file too.  I would check to see if you have some really old backup files sitting in...

Another thing you could do is have a calculation table.  Presuming that there is some correlation between size and quantity in some cases.
That way if you have some correlation...

Not sure this suits your needs or not, but what about selecting it into a table like this:
declare @linkedserverName varchar(100) = 'servername'
declare @DB_rename varchar(100) = 'DBName'

I got tasked with a similar thing recently and something else to watch for is user that is created without login or user that is created with a login of...

Just so I understand correctly, you have a comma separated list in a flat file and you want to select out of it?
If this is correct, you would want...

Yep, that makes a bit of sense.

As for the section:

            
June 29, 2017 at 2:45 pm
            
#1948834

            
            
                                                
        

I got this one:
SELECT CASE WHEN [CYsales].[cust_id] IS NULL THEN [LYsales].[cust_id] ELSE [CYsales].[cust_id] END AS [cust_ID]
 , [CYsales].[sales]
 , [LYsales].[sales]
FROM [CYsales]
FULL OUTER JOIN [LYsales] ON...

I am just curuios why would you want to break that up into 2 statements instead of 1?
I know you can, I'm just not sure what the benefit would...

Could do it outside SSIS as well (if that is an option).
If it is required to do it from SSIS, I think either looping, or if you have xp_cmdshell...

2 thoughts:
1 - are you on the latest SP/CU?
2 - I think this error might have a bit more to it:
Errors were encountered in the procedure 'dbo.apspuRackUpNextUsed'...

Not meaning to bring back a dead post, but kind of curious what happened with this?
OP - did you get more memory in the system?