Warning: The Call Text attribute of Stored Procedure transformation <transformation name> has non-empty value when the Stored Procedure Type attribute is set to Normal.
The call text attribute for the stored procedure contains a value when you defined the stored procedure type attribute as Normal in the XML file.
Edit the XML file and make sure the call text attribute value is empty when you define the stored procedure type attribute as Normal. Or, export the object again and then import it.