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?

I could be dumb, but when I look at your calculation and your input flat file, I think you are over-working the date are you not?
the date in the...

This is for log shipping, correct?
If so, did you see this post:
https://www.sqlservercentral.com/Forums/1103972/extremely-slow-log-shipping-restore-in-standby-mode?PageIndex=2

The "best" solution that I see from there was from

June 28, 2017 at 2:32 pm

#1948643

It could be SQL server version related, but if you are running it from your local machine, it shouldn't much matter from my experience.  I had an SSIS 2016 package...

Looking at the error and the naming of things in there, I'm guessing you are missing sharepoint connectors on your system.

The reason I think this:
1 - you...

As a thought, did you change the compatability of the database after upgrading?  

I tried looking up that SP on bing hoping to find something related to it (which...