you need to install SSDT.

either with shell for vs2017 https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017
or 
for vs2012 https://www.microsoft.com/en-us/download/details.aspx?id=36843

do you have the explain plan of the proc that is being executed inside the code of the plans you supplied? TARIFF_SIM_MATRIX_3M is being executed on a loop and 
both...

the issue is that the last line fails to meet the correct delimiter "\"\r\n" and as such the value contains a quote

try changing the table to
create...

It would be great if everyone had enough space and time to move tables from one filegroup to another to be able to shrink files. few have though.

In...

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.