CODEWITHSUNDEEP
sql-serverssisibm-midrange
Mohammed Mushtaq
Mohammed Mushtaq

Reputation: 31

Calling As400 procedure in SSIS

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

Upvotes: 0

Views: 1572

Answers (3)

userpk
userpk

Reputation: 1

This is achievable via the script component.

  1. Script component>>Destination
  2. Create a User Variable for the connection manager, and call the same in the script component.
  3. Write the script to call the stored procedure

This worked for me.

Note: I am using Kingswaysoft tool kit script component.

Upvotes: 0

il_guru
il_guru

Reputation: 8508

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];

Upvotes: 1

Santiago Cepas
Santiago Cepas

Reputation: 4094

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.

Upvotes: 0

Related Questions