on your catch block output the error exception (and inner exception if any) to your log file and see exactly what the error is.

One thing that is likely...

have  you tried setting Delayed Durability? just to see the impact - and permanent setting if it improves and the DB can leave with it on (or at least the...

install SQL Server 2017 express and make sure the path for its executables is on your path variable

select convert(decimal(10,2), replace(replace('"6,789.01"', '"', ''), ',',''))
would do the trick - but if using SSIS or other tools those sometimes handle that on their own without any...

Can't people read manuals anymore? it is quite clear what you need to do on it.

https://docs.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-2017

Yes the process will need additional space - original index/table + the new one - new one can be build on tempdb or on the destination db itself.
Log file...

From your latest posts on the forum it looks like you are trying to learn to use sql server - as part of that learning process your most important task...

it may not be as easy as you would like.

It will all depend on how your packages are build, executed and where they are stored.

Storage
-...

Maybe you have already considered these but still worth mentioning.

http://www.sqlservercentral.com/articles/SQL+Server+Data+Tools+(SSDT)/156986/
http://blogs.solidq.com/en/sqlserver/ssdt-how-to-solve-the-circular-references-issue/

but in any case its never straightforward.

if you change you call code to be

long lTimeStamp = d.getTime();
UUID uuid = UUID.randomUUID()
sql.call("{call pCreate_TestRec(?,?,?)}", [uuid, 'test', lTimeStamp] );

does it work?