How to copy data from a CSV file to a table in Vertica Data Base by using command line (CMD)?

So you are in a DOS box of a Windows system.

Add an environment variable to your account, by hitting the magnifying glass next to the Windows button at the far low left corner of your Windows screen, and type "Environment variables". You will see a list of hits, among which "Edit Environment Variables for your Account" and "Edit the system environment variables". Click on either of the two, depending on whether you want it for yourself or for the whole Windows system.
Add 4 variables with the [New ...] button, for example:

Variable         Value
VSQL_USER        dbadmin
VSQL_PASSWORD    dbadmin_s_password
VSQL_HOST        <ip address or host name>
VSQL_DATABASE    <database name, for example vmart>

and edit the variable:

Variable         Value
PATH             <what is already there>;C:\Program Files\Vertica Systems\VSQL64

then go:

cd /d <the directory where your data file resides, not necessarily vsql.exe>
vsql -c "COPY planning.sap_mx_env_me2n_zaaptr_zpaitr_envase_transito ^
(planta, folio, des_proveedor, fecha_carga, hora) ^
FROM LOCAL 'C:\Users\geradiaz.MODELO\Desktop\Envase\Transitos\Outputs\Transitos.csv' ^
DELIMITER ',' SKIP 1 EXCEPTIONS 'con' REJECTMAX 3"

Thanks for reply @marcothesane
Seems a nice way to try, just one more quick question, do you know if I can create a notepad file or something like that instead of create Environment Variables? The other problem here is that I'm on a server and don't have administrator permission and that requirement could take so long.

I hope you can help me.

Cleanest way would be:
A batch file:

REM copyexample.bat
@ECHO OFF
set VSQL_USER=dbadmin
set VSQL_PASSWORD=password
set VSQL_HOST=marcos-ubuntu
set VSQL_DATABASE=sbx
"C:\Program Files\Vertica Systems\VSQL64\vsql.exe" -f copyexample.sql

and the copyexample.sql sql script you're calling in the batch file:

-- copyexample.sql
COPY planning.sap_mx_env_me2n_zaaptr_zpaitr_envase_transito
(planta, folio, des_proveedor, fecha_carga, hora)
FROM LOCAL 'C:\Users\geradiaz.MODELO\Desktop\Envase\Transitos\Outputs\Transitos.csv'
DELIMITER ',' SKIP 1 EXCEPTIONS 'con' REJECTMAX 3
;

thanks a lot @marcothesane I'm gonna try it, your solution makes sense for me, best regards!