I tried calling an AS400 stored procedure in SSIS using an execute sql task.
The task started executing but never completes and I am not getting any error messsage. There is no problem with AS400 stored proc.
I used ADO.Net - ODBC connectivity to connect to AS400 server using IBM client access driver. Please let me know if there is any way to call an AS400 stored proc.