Re: Executing ISeries program or command from MS SQL Server SSIS

From my understanding you should be able to execute C# or VB.Net code 

routines from within SQL Server 2005.   Haven't tried this myself yet.

If this works as expected you should be able to use the .Net data provider 
to call an iSeries program. 

Regards,
Richard Schoen
RJS Software Systems Inc. 
"Providing Your....iNFORMATION NOW!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT

------------------------------

message: 8
date: Tue, 30 Jan 2007 14:29:08 -0800 (PST)
from: Don <dnmcin@xxxxxxxxx>
subject: Executing ISeries program or command  from MS SQL Server SSIS

I need to execute an ISeries program (CL or RPG) or command from within an 
Integration Services package within SQL Server 2005.  I need to initiate 
it from within a MS SQL Server SSIS package. 
 
  I know how to call an ISeries program in a .bat file using ISeries 
Access, or within a Java program.   Therefore I assume I could also call a 
local application to initiate the call, but would prefer to call directly 
to the ISeries.  I don't know how to call either one though from within 
SSIS.
 
  Has anyone done this before, and could help point the way for me?  I'm 
new to MS SQL Server.  My PC is running XP Pro, and my ISeries is v5r2. 
 
  Thank you,
 
  Don McIntyre