Calling As400 procedure in SSIS

Question

HI All,

I have created one simple stored procedure in AS400. It has only one input parameter and I compiled and created it successfully. Now I need to call this procedure in SSIS to move data from source to destination. Here my source is As400 procedure and destination is Sql server table.I have goggled lot to find how to call the procedure in ssis but nothing works on my end . I need some help from you guys.

Thanks Mushtaq

Answer 1

You can use an OLE DB provider for AS/400.

I've used (a looooong time ago) the Hit Ole DB provider, and it worked great. Also, you can use Microsof's Host Integration Services

I'm afraid both are commercial products. To my knowledge there is no free alternative.

Answer 2

If you have a linked server you can use the EXEC command to start the procedure from an SQL task. The CALL command should work as the AS400 CALL

EXEC ('CALL LIBRARY.PROCEDURE') AT [LINKED AS400 NAME];