Not sure on the warnings, but it sounds like the objects already exist and you are trying to drop something on top of them.
The error is because on the...

When you say DSN, I am assuming this is an ODBC connection?  If so, those do not store the password for the credentials.  You can verify this by looking at...

That changes things (good thinking Gail!).

The instead of trigger would change how the insert is performed.
I imagine you'd want to disable the trigger, do the insert, enable...

Which part is slow?  The loading of Excel into the staging table or merging the staging table into the live table?

You are using SSIS.  How much memory does...

I just ran the above code with minor modifications and it ran without any problems.
The modification I did was to change it from a permanent table to a table...

I try to own the mistake if it was me who made it and I use that to update our release documents to prevent it from happening in the future...

This line looks a bit odd to me too:
SET @TABLE_NAME = (SELECT...

I am slightly confused.
I took the code, copy-pasted it into SSMS 2016, connected to a SQL 2016 SP1 instance and ran it.  I got a different answer than the...

As a thought, does this query give you any results:
SELECT *
FROM tblA
WHERE tblA.id NOT IN (SELECT id
     FROM tblB)

July 12, 2017 at 4:03 pm

#1950657

May actually have a solution for you:
https://support.microsoft.com/en-us/help/3053960/fix-a-system-assertion-in-longrec.inl-1318-occurs-when-you-rebuild-or

I see you posted this in the SQL 2016 section and the above article applies to SQL 2012.  I'm guessing...

The other thing you can do is go into the SSRS web portal, navigate to the folder that has the reports to remove, change the view type to "list" instead...

2 things come to mind:
1 - did you run DBCC CHECKDB to ensure the database is not corrupt?
2 - did you check the SQL Server error log for...

Another thing to watch, if you are using an SSIS catalog (might apply to the non-catalog method too), the job doesn't need to reside on the same server as the...

Adding to what has been said, I am slightly confused as to why you would manage the subscriptions for end users.
I understand if the subscriptions are emails being sent...