I scanned through this...so maybe I missed something, but I think the OP mentioned that this will be an SSRS report that will then be extracted to Excel.  SSRS does...

The technical answer is - it depends...
If you plan on scaling the solution out to support a large number of reports and/or users then I would recommend separating the...

You should be able to use SSDT 2015 to deploy to the Integration Services Catalog in 2016.  Can you confirm the version you are deploying to?  Open a query window...

Sorry this is so late - been quite busy...it seems you are deploying to a server that is at a different level than what you are developing.  If you are...

You are going to have to recreate your script task - after changing the target version.  If you created the script task prior to switching the target version - then...

If you have Enterprise Edition you could try setting up a data-driven subscription.  You would then create a query that pulls the necessary information from SQL Server - where you...

You stated you have 2 instances on this one server - what are the min/max memory settings for each instance?  You also stated that the committed memory is 99% which...

What version are you using?  If it is 2012 or above - you should change your deployment model to use the Integration Services Catalog.  Using that model you don't need...

If you are looking to search objects - and not values in columns - then I would recommend downloading and installing SQL Search from Redgate.  Does exactly what you want...