Call Stored Procedure step fails at task runtime with error 0x80040e21

Symptom

When a task contains a Call Stored Procedure step that accepts parameter values, it may fail at runtime with the following error:

0x80040e21

Cause

Occurs when the parameter value can’t be converted into the specified data type. For example, if a stored procedure requires a parameter type of DBTIMESTAMP and you pass it a value of ‘1’, then the problem will occur. Whereas if you pass ‘10/10/2003’ then the fault will not occur.

Resolution

Ensure that the parameter value is correct for the specified data type.