When the Execution Order attribute is grayed out in the Stored Procedure Transformation properties, how to change the execution order of unconnected (Source Pre-load or Source Post Load, Target Pre Load or Target Post Load) Stored Procedure Transformations in a mapping?
To change the execution order of the Stored Procedure Transformations in a mapping, do the following:
Go to Mappings > Stored Procedures Plan.
In the Stored Procedure Execution Plan window select the type of Stored Procedure (Target Post Load, Source Pre Read, etc.).
Highlight the Stored Procedure Transformation name.
Use the up and down arrows on the right side in that window to move the Stored Procedure to the desired location.
The Execution Order number of each Stored Procedure can be verified under the Properties tab:
HOW TO: Pass a mapping variable to a Stored Procedure transformation (18430)
What can we do to improve this information (2000 or fewer characters)