DB2-AS400 to SQL 2005 Adapter

I am attempting to create a solution that will move data between an AS/400 DB2 database and a SQL 2005. I have installed and am successfully using the Host Integration server to receive data from the DB2. I can send this to a FILE successfully as well. I can’t send this to a SQL stored procedure though. I am using a sproc because I am using the INSERT_IDENTITY method and the Updategram will not allow me to insert into the primary key since it is an identity field.

Right now, when I use the send port I get an error message saying:

The Adapter “SQL” raised and error message. Details “HRESULT=”0x80040e14″ Description=”Could not find the stored procedure ‘STOREUNT’.”

This is the name of the table/file from the DB2 file and I don’t know why the SQL Schema exec line is being replaced with this one.

I hope this makes sensse and somebody can tell me what I am doing wrong. Thanks