Error: Failed to expand call text <text> for Stored Procedure transformation <transformation name>.
The Integration Service cannot expand a parameter or variable in the call text of the Stored Procedure.
Verify that the parameter or variable is defined properly in the parameter file and that its value in the parameter file matches the parameter or variable datatype. For example, you cannot set an integer mapping variable to a text string in the parameter file.
The Integration Service cannot expand a parameter or variable in the call text of the Stored Procedure due to an internal error.