Execute Bat from "Execute Process Task" - SSIS

• eric200190

  SSC Veteran

  Points: 275

  More actions

  December 1, 2015 at 8:42 am

  #305715

  I´m trying to pass 4 parameters in an "Execute Process Task", that task executes a .bat that has an store procedure with 2 parameters.

  Arguments in the "Execute Process Task":

  "\""+@[User::vServidor]+"\""+","+(DT_WSTR, 5)2.45+","+(DT_WSTR, 8)20151201+","+"\"\\PC\\Actualizar Data LCLW05 CSF\\Logs\\txtooo.txt\""

  Code inside the .bat:

  sqlcmd -E -S %1 -d BDTest -Q "EXEC dbo.ESL_spActualizarDataLCLW05 @TipoCambio=N'%2', @MaxFechaDesembolso=N'%3'" -o %4

  When i execute that task, it gives me the next error:

  [Execute Process Task] Error: In Executing "\\PC\Actualizar Data LCLW05 CSF\Solucion\Archivos Insumo\Ejecutables\Actualizar Data LCLW05 CSF bien.bat" ""ServerBD",2.45,20151201,"\PC\Actualizar Data LCLW05 CSF\Logs\txtooo.txt"" at "", The process exit code was "1" while the expected was "0".

  Any ideas of that error????