Do read the following paper https://download.microsoft.com/download/9/C/6/9C6EB70A-8D52-48F4-9F04-08970411B7A3/SQL_Server_2016_Licensing_Guide_EN_US.pdf.

It does go into detail on how the whole licensing works. And even after reading it you should confirm with Microsoft so ensure...

error is quite clear - did you install the ACE driver on the server where you are running the package? and if it is a server why not install and...

With standard even if you set max memory higher it will only use the 128 so do not worry about that aspect. So the correct thing to do here is...

128GB is max that SQL Server instance will use for its buffer pool - and this is per instance.

but as there are other things that can use the...

Lets assume the following example
Standard process would be
- dataflow -
  Input file to Final table

Approach I am suggesting is
-...

What is the Oracle client you are installing? link to Oracle download if you can.

And where have you seen that the 32 bit driver will only be released...

I use the following to get my dependencies.

Only works with objects within the same database - so if there are references to external databases it won't find dependencies...

SSMS version has nothing to do with the Instance version - they are 2 independent products.
you could easily be using SSMS 2017 with a 2008 R2 database

So...

from the licensing terms at https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools-license-terms

Installation and Use.

  You may install and use any number of copies of the software on your devices to design,...

Setting compatibility mode is a database level permission (alter database) if not mistaken.

create user is securityadmin or alter any login (no need for sysadmin)

CLR is...

only differences between Developer and Enterprise is that the enterprise version may be limited by the number of cores it uses.
If for some reason the Enterprise version used is...