Execute Process Task to execute a .jar

• HankL

  SSC Veteran

  Points: 239

  More actions

  May 21, 2013 at 12:05 pm

  #394820

  I'm trying to run an Execute Process Task that initiates a java program. The error I receive when I run it in debug mode is: [Execute Process Task] Error: An error occurred with the following error message : “The specified executable is not a valid application for this OS platform.”. The Process fields in the Execute Process Task are filled out as follows:

  RequireFullFileName = True

  Executable = C:\Users\john.doe.corp\Desktop\Calc\rollupcalc.jar

  Arguments = java -classpath .;rollupcalc.jar co.corp.Application filename.csv 12

  WorkingDirectory = C:\Users\john.doe.corp\Desktop\Calc

  All other fields are left at the default value.

  Any and all help will be greatly appreciated.

  HankL.

• Vikash Kumar Singh

  SSC Eights!

  Points: 974

  More actions

  May 27, 2013 at 8:19 am

  #1618794

  I do not come from a Java background. I do not even know the suggestion below might help you or not but still putting my thought here.

  I assume that you are running a Java Program. Can you run this Java Program using Command Prompt or simply by putting the program name(jar) and arguments in RUN window. If so I think you are on track.

  Why not you create a batch file and put all the program name, arguments, working direcotry into it. Run that batch file from SSIS (Execute Process Task).

  Vikash Kumar Singh || www.singhvikash.in

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  May 30, 2013 at 4:45 am

  #1619614

  Windows does not know what to do with a file with a .jar extension by default. You will need to pass the path to the .jar into the JRE using a fully qualified path to the runtime (e.g. C:\Program Files\...etc...\java.exe) in your Execute Process Task and making the reference to the .jar file a command line argument.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato