adpr0401 i've seen the same issue multiple times since the last...

use powershell, it will be easier;
i googled "powershell export ssis package from integration services catalog" and the first four script hits  all look familiar enough to work for you.

tables and views are easyto convert, but procedures that do stuff meta-data wise will require a complete re-write.
checkdb? kind of equivalents are CHECK TABLE , REPAIR TABLE , ANALYZE TABLE 
reindex? backup and...

i run something like this that installs all my standard scripts on a given server.
you are really asking how can i add an outer loop to this, so ii...

this linky shows how you can peel the orange with a chainsaw:
instead of simply downloading all the projects and using a text editor to search the *.dtsx files, this...

here's what i did: narrow down what table it could possibly be:
SELECT
OBJECT_SCHEMA_NAME([colz].object_id),
...

i seem to remember that the package_data column of the SSISDB.[internal].[packages] is actually an encrypted value stored as a varbinary columns, so you cannot cleanlyconvert it to search the xml...

can you check to see if the .Net 3.5 library was installed? unless you hand edit a config file, you could install say, SQL2014 or 2016, and db mail does...

i have a job scheduled on each server that contains a reportserver database that updates the job description with the report name, so it's much easier to track down that...

certainly possible, but something like that sounds like it needs to be part of the dynamic generation processes, and not a cleanup after the fact.
the problem is we don't...

sys.dm_exec_sessions has whether a spid/session_id is a user process or a system process.

thios seems to work for me, is this what you are after?

SELECT...

I would think the log would be useless, as it has what was successfully committed, and is not a log of errors and what did NOT get inserted.

you...

jayoub i think you have to avoid using sqlcmd in this case, and create a simple SSIS package isntead.
I knew two things right away that were affecting you:
you...

I believe the issue is the Service Principal Names (spn) on one or both of the servers in question is not set up, so the Windows credentials do not get...