SSIS: Value does not fall within the expected range

SSIS Error

[Execute SQL Task] Error: Executing the query "EXEC dbo.sp_name ?,?,? OUTPUT" failed with the following error:

 "Value does not fall within the expected range.". Possible failure reasons: Problems with the query, 

"ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

When you are trying to execute a stored proc though execute SQL task:

you can call sp like 

            EXEC dbo.sp_name ?,?

when there is no out put parameter

and like 

           EXEC dbo.sp_name ?,?,? OUTPUT

where there is an output parameter.

If you try to assign parameter names like above in this case you will receive error that 

"Value does not fall within the expected range."

and it gives no clue whats so ever regarding the issue with the task

this can be fixed by replacing actual name of parameters in Parameter Name Column for Index location of the parameter that you have defined in your stored proc 

and  parameter mapping tab is going to look like and  Bingo your error is gone....