have a look at my post on https://www.sqlservercentral.com/Forums/1866405/dbcc-shrinkfile?PageIndex=1
by setting @shrink_target to your desired value it will do what you need.

from the old RTFM https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=ITECHREF_exporting

reading the manuals may identify other ways of doing it. and their forums probably have other info.

just noticed that this is being called from a SSRS report. In addition to what I said you also need SSRS to be

running using a AD account
Have...

if you need to cache that many rows you should probably redesign the package so that those joins are done in SQL Server itself and not on SSIS.
even if...

I might be interested - Not specifying particular areas of interest but if I feel uncomfortable with any area I will state if/when requested to review a article.

being slow is a different issue.
look at the logging of that package (if running from the command line as you are, /reporting EWIC should be on the command line),...

just to clarify.

Access runtime 2016 installs both 2012 and 2016 drivers. However there is functionality on the old 2010 + sp1 that has been removed from teh 2016...

was the Microsoft Access runtime installed on the server? https://www.microsoft.com/pt-pt/download/details.aspx?id=10910 and corresponding sp1 https://www.microsoft.com/en-us/download/details.aspx?id=26602. Not sure if SP2 gives same functionality - newer versions removed some functionality from the driver.

why can't your SSIS be the 64 bit one?
are you using the Integration Services object model directly on your code?
or are you calling a external DLL from...

I think that even with DEVOPS size of organization will often dictate how much accumulation of roles one can have.

On my current shop and up to maybe 6...

timings is going to depend hugely on the spec.
on my laptop (I7-8550-U 1.8GHz - 16 GB ram) with SSD

times are as follows
T_TEXT     ...

you need 
- domain account for the SQL instance
- domain account above needs "trusted for delegation"
- SPN for domain account and sql service need to be set -...