SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Use SSIS package to run JAVA code
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vithaljs
Starting Member

India
12 Posts

Posted - 12/29/2010 :  02:53:21  Show Profile  Reply with Quote
Hi,

Can we integrate the SSIS with JAVA application?
i'm trying to integrate the java application to existing SSIS. Is it possible? If yes, then how can one do that??



vithal

latch
Yak Posting Veteran

62 Posts

Posted - 12/30/2010 :  09:48:57  Show Profile  Reply with Quote
Hi,

I think Execute Process task & BCP are used to execute java related files.



Thanks,
latch.
Go to Top of Page

sunilenugala
Starting Member

India
1 Posts

Posted - 06/05/2013 :  02:40:37  Show Profile  Reply with Quote
We can process Java Class/rar file in three different ways...

Please go through my blog link to know about the process.

msbimentalist.wordpress.com

Regards
Sunil reddy enugala
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 06/05/2013 :  02:45:39  Show Profile  Reply with Quote
Unless there is a compelling reason like some data manipulations etc you dont need SSIS for this.
You can very well write a batch file for processing java app from commandline for that.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 06/05/2013 :  02:52:42  Show Profile  Reply with Quote
Also batch scripts can be scheduled from SQL Server agent/windows scheduler for automated execution.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000