I have written a stored procedure that accepts 33 parameters. I am trying to execute the stored procedure from a SSIS OLE DB Command task. The code I am putting into the "SqlCommand" property is "Exec dbo.CO_PROD_UPDATE ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?

What error are you getting?

error at Perform Updates [Update Production [125]]: an OLE DB error has occurred. error code: 0x800004005, an OLE DB record is available.... "syntax error, permission violation or other nonspecific error. " I am pretty sure my syntax is correct, and I can execute, edit, and drop stored procedures, so I don't think it is a permissions issue. Craig

Another thing I noticed is that I can execute a stored procedure from the SSIS OLE DB Command task if the proc does NOT take any parameters... Interesting situation... Craig

Hi...Follow the link for the solutionttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=572199&SiteID=1

Hello all, my co-worker sitting vis-á-vis has just received the same error message submitted by Craigster. Any chance to find the solution in the new forums? Thanks in advance and best regards, Gerald