see if this applies https://support.microsoft.com/en-ie/help/3041857/code-0x80070057-the-parameter-is-incorrect-error-when-you-try-to-displ

use the try catch block.
after the try catch do another bulk insert this time of the error file - if any record is loaded you had errors on the...

load the file onto a table with a single column (varchar(max) - or whatever size is enough to hold a single record)
and then do parsing and validation in t-sql...

first I wonder if the syntax is correct
EXECUTE AS LOGIN='[domain]\';
possibly should be
EXECUTE AS LOGIN='[domain\user]'; -- brackets around all of the domain\user, not around both domain and user

you need to go and read the manuals in more detail - and google as there are plenty of good examples.

This is a beginners question.

... a...

gee. why did they install a 32 bit SQL version?

and you should really forget that those 2 options exist - pure evil.

If you have locking issues look into the possibility of enabling READ_COMMITTED_SNAPSHOT your database.
Depending on your...

I fail to see where the SQL Job belongs on your VBA process.
From VBA you can call the proc directly passing whatever parameters you wish.

from what you...

unless you are using a evaluation version then you won't have it.

otherwise the SQL Server license does not expire.

If you have SA this does expire if...

easier does not mean better or correct.

And as the output is being loaded by a COBOL program what is the exact layout it needs?

fixed length file?

and most important where is the code you surely have already tried to do to address your requirements.
As well as the rules and the desired output.

And that...

you still didn't understand the main issue.

Most people will not download a file that can contain anything at all.

DDL and SQL unless extremely big (10K lines...

In my current (and some of the previous) company we definitely have audit controls.
Not in all systems (yet) but at least on the core ones.
so every time someone...

similar results for me 

As the results I had given before only related to the date part I've also run your code with just the date bit.
and also...