Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execute java in Task Expand / Collapse
Author
Message
Posted Monday, December 14, 2009 4:27 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 14, 2011 3:48 PM
Points: 51, Visits: 222
Hi, I have a jar file and i need execute it sentence:
java -jar openpgp.jar -d "c:\example.asc" "c:\file pgp\readme.txt.asc"

In Integration services, is there any task that execute this sentence?
Thanks.

Post #834234
Posted Tuesday, December 15, 2009 7:57 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:30 AM
Points: 346, Visits: 518

Yes - you can use execute process task in order to do this. Go to process and you can specify the executable and the required arguments..



--
Sabya
Post #834522
Posted Monday, February 1, 2010 1:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 8, 2013 3:17 PM
Points: 12, Visits: 56
Hi,

I need to do something similar. Did you get this working?
Post #857547
Posted Monday, February 1, 2010 4:41 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:30 AM
Points: 346, Visits: 518

Did you at least try?


--
Sabya
Post #857636
Posted Tuesday, February 2, 2010 7:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 8, 2013 3:17 PM
Points: 12, Visits: 56
Thanks for your help Sabya.

I ended up using a bat file and executing it from the Execute Process Task in SSIS. I was hoping that I wouldn't have to use a bat file to execute the java code but I couldn't get the Execute Process Task to run that way. Who knows if you can actually run it that way.

What I don't get is why you even bothered to post to my thread. If you were annoyed by my post, then why wouldn't you just ignore it and move on? So, it seems that all you succeeded in doing is wasting your time, my time, and the time of everyone reading this post.

Thanks again for your help, Sabya.
Post #857958
Posted Tuesday, February 2, 2010 5:47 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:30 AM
Points: 346, Visits: 518

Yes - you can actually run this. Also this is the reason I asked if you have tried the approach at all. I bothered to write hoping you might post the error or problem you encountered while trying the solution provided...



--
Sabya
Post #858334
Posted Wednesday, June 27, 2012 6:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 14, 2014 1:18 AM
Points: 46, Visits: 114
i got this error when i tried this type of task.

can anyone suggest me about the error?

Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Post #1321817
Posted Thursday, June 28, 2012 12:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:49 PM
Points: 13,283, Visits: 10,156
Reddy Ksr (6/27/2012)
i got this error when i tried this type of task.

can anyone suggest me about the error?

Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.



This is a warning saying you have too many errors. So you need to post the actual errors as well.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1322298
Posted Sunday, June 2, 2013 1:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 31, 2014 12:44 AM
Points: 19, Visits: 378
Please go through my blog posts on executing java class file from SSIS.

[/url]

[url=http://msbimentalist.wordpress.com/2013/06/02/execute-java-class-file-from-ssis-part-2/]


Let me know your queries further.



sunilreddy
http://msbimentalist.wordpress.com
Post #1459029
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse