sql - SSIS Generic Error for SP Execution -

in each loop container , each job reference.

i running execute sql task list of 21 input parameters stored procedure ( task 1 ). input parameters stored in ssis variables.

then have execute sql task run stored procedure, set 21 input paramters , output parameter. ( task 2 )

when running package fails @ task 2 following generic error:

error: 0xc002f210 @ run sp_insert_package, execute sql task: executing query "declare @testfaultstageid int declare @testid..." failed following error: "multiple-step ole db operation generated errors. check each ole db status value, if available. no work done.". possible failure reasons: problems query, "resultset" property not set correctly, parameters not set correctly, or connection not established correctly. task failed: run sp_insert_fault2 error: 0xc002f210 @ run sp_insert_package, execute sql task: executing query "declare @testfaultstageid int declare @storeid..." failed following error: "multiple-step ole db operation generated errors. check each ole db status value, if available. no work done.". possible failure reasons: problems query, "resultset" property not set correctly, parameters not set correctly, or connection not established correctly. task failed: run sp_insert_fault2 warning: 0x80019002 @ 02-01-02-epoch-jobs-load: ssis warning code dts_w_maximumerrorcountreached. execution method succeeded, number of errors raised (2) reached maximum allowed (1); resulting in failure. occurs when number of errors reaches number specified in maximumerrorcount. change maximumerrorcount or fix errors.

i have tried find error, checking data types , conversions , other stuff no luck far. there easy way track down or narrow down cause ?

sql server 2012

in execute sql task component, in sqlstatement field, should have question marks (?) set in place want put parameters. should defined in parameter mapping tab.

are sure set correctly? share sqlstatement field value?