If you have enough total space - create multiple files in the primary file group on the destination server that has enough space allocated for all the data you want...

Are you concerned with how the data is going to be inserted into a table?  If so - then you can stop worrying because tables do not have an order...

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...