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.