Execute Java Class file from SSIS – Part 2
Posted by Sunil Reddy Enugala on June 2, 2013
In my previous post I have shown you how to execute Java Class file, let me show another process to execute Java Class file.
In this process
- We are executing java class file using a batch file.
- We have to hardcode the file path in the batch file.
- No need of configuring SSIS variables.
- Not flexible as process 1.
- Simple than process 1 as we are hardcoding everything.
I have placed java class file in D:\FileDeletion\ path. Please go through the below figure to know about the content of batch file.
Syntax to execute Java Class file:
java –classpath <folder path of class file> <filename of class file without extension> <parameters>
I have placed batch file in the same folder(D:\FileDeletion\ ).
Drag a Execute Process task in SSIS Control Flow Designer pane, Edit the Executable and WorkingDirectory properties as shown in below figure.
I have placed the file which needs to be deleted in following folder path.
Please let me know your comments and queries.
This entry was posted on June 2, 2013 at 6:24 pm and is filed under MS BI Related. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.