Jeffrey Williams:  Thanks for the link!  Much appreciated.  I will definitely be looking at that.

Jeffrey Williams:  Oh that's simple: Because I had never really heard of Integration Services Catalog before your post.  (sigh)  I did see the text "Integration Services Catalog" in Object Explorer...

Phil Parkin:  I researched the MaxConcurrentExecutables property.  Thanks for bringing it to my attention.

As you suggested, I changed the value to 1 and re-imported the package into the MSDB database. ...

Thank you Phil Parkin!  The package definitely does not have any encroaching tasks.  I will give your suggestion a try.

Mr Brian Gale:  Thanks for the added clarification.

I have some more info in case that sparks any more thoughts for you:

You asked about whether the SSIS package had been updated....

Chris Harshman:  Thanks for the added input.  Much appreciated.

I think I remember reading about that Cardinality Estimator thing you are talking about.  I didn't understand what the Estimator is, but...

Mr. Brian Gale:  Thank you soo, sooo much!  I will look into all of these things and let you know what happens.

I think I see your point!  Thank you for taking the time to clarify.  I will make sure all my Users on my new server have Logins.  No more orphans...

Davis:  Thanks for answering my question!

To answer your question about why I keep the orphaned users:  The Users from group #3 above are required, because I have to have a...

This may have been a bad question on a couple fronts.  Can it be deleted?

I found another discussion that says using 'sa' is not a terrible choice and you can't...

This is why I so strongly...

We use active directory to handle security for our internal applications also. I think it is a great method as our Help Desk staff can handle security maintenance this...

Cute! Well done.

This is a nice way to make recompense. And fun for us.

Here's a query that I used in production

--the row_number() function returns a bigint data type, which is

--why we...