My opinion - each "feature" of SQL that you enable requires knowledge and skills on how to work with it.  For example, if you turn on memory optimized tables, do...

From looking at that, the problem is indicated in the first error - Parameter arrays with data at execution are not supported by the MySQL/MariaDB ODBC driver.

If you have a table with a clustered index that you cannot rebuild or reorganize, I think the ONLY other thing you could do to reduce the fragmentation percentage would...

I'd have a read on this page:

https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-heaps-and-their-fragmentation/#:~:text=In%20SQL%20Server%2C%20heaps%20are%20rightly%20treated%20with,that%20space%20is%20allocated%20and%20forward%20pointers%20used.

But basically, "alter table <tablename> rebuild" will rebuild your heap.

Does that table need to be a heap or would it benefit from an index?

Just to confirm, if you log into the server while the job is running and load up task manager, who does cscript.exe say it is running as?

The reason I ask...

Just my opinion, but do you need ALL of the ERP data?

The reason I ask is if you aren't needing all 130 GB of data, it MAY be faster to...

What is likely happening is sys.tables is getting a lock due to the SELECT * INTO TableName which would create the table AND do a select in a single transaction...

Making a guess here, but is that a TABLE or a VIEW or STORED PROCEDURE?  I am just trying to imagine designing a system that will alter a table to...

What about UNC path vs drive letter or is the file stored locally?

As another thought, are you using the 32-bit driver or the 64-bit driver?

This is the link I found...

Another option (others may shoot this down as a bad idea) would be to turn on filestream access on the folder and have the SQL side mostly pulled out of...

I second Ken's approach.  I like having my application logic at the application layer and my database logic in the database.

I would much rather have 2 stored procedures (pre java...

One other thing you will want to be certain of is that the drive letter doesn't change.

It USUALLY doesn't from a format, but I've seen Windows do stranger things before.

CXCONSUMER was introduced in SQL Server 2017 CU3.  14.0.2037.2 is NOT CU3.

you are not "patched to current" as current SQL Server 2017 is CU23 which is version 14.0.3381.3

Even CU3 is...

I agree with you 110%!

I almost always use CTE's over nested selects.  I find them easier to read and easier to test and debug. "SELECT * FROM <cte name>" after...

From my experience, nested selects vs CTE's have had very similar performance.

If you have a SQL formatting tool (such as RedGate SQL Prompt or ApexSQL Refactor), I would start by...