You mention databases, are some of the objects in different databases?  That would certainly not show up here.

not sure why, when I replace the procedure name in the function call:
OBJECT_ID('dbo.SP1','P')
I get listing of all views, tables, functions, and other procedures...

If you keep the 3 SSIS packages separate and have a SQL Agent job with multiple steps, it will be much easier to rerun the later steps if a step...

you can try to recursively query the metadata like this:

-- objects referenced by specified stored proc
;WITH ref_list AS
    (SELECT o.object_id, OBJECT_SCHEMA_NAME(o.object_id) AS schema_name, o.name...

I think maybe you just need multiple WHEN clauses in the CASE, instead of multiple CASE statements.  maybe something like:

update table
set col1 =
    case

I'm not quite sure what you're trying to accomplish, but offhand it would seem the SSIS package would have nothing to do with any database transaction in this case.  You'd...

by client do you mean just the native client libraries, or actual client tools like Management Studio, SQLCMD, etc.?  In general, you can have multiple versions of the client libraries...

Funny thing... documentation seems to say that SECURITYADMIN would be enough to perform database level permissions:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles
but I tried it out in a sandbox environment without db_securityadmin, and...

is it possible that the SomeUsers group is a member of another group that does have a login on this instance?  You can try this to see what the "permission...

I'm thinking the statuses have a priority, not necessarily that the logic conflicts.  Here's my attempt, with results similar to Scott's:

CREATE TABLE T_USERPROCESS_STATUS
    ( varchar(6),

If all the SSIS package is doing is calling the batch file, then why couldn't you just use a job step of type "Operating system (CmdExec)"?  You can setup credentials...

Yes, you can restore backups of user databases to the new SQL Server, and it will perform any needed upgrade as part of the restore process.  You don't want to...

in newer versions of SQL Server you could probably use windowing functions with your count:
http://sqlmag.com/sql-server-2012/how-use-microsoft-sql-server-2012s-window-functions-part-1