You process a stored procedure with a connected SQL transformation when you need data from an input field sent as an input parameter to the stored procedure, or you need the results of a stored procedure sent as an output parameter to another transformation.

You process a stored procedure with an unconnected SQL transformation when you need the stored procedure to run before or after a mapping, run nested stored procedures, or call the stored procedure multiple times.

The following table describes when you would use a connected or unconnected SQL transformation to process a stored procedure:

Scenario	SQL transformation type
Run a stored procedure before or after a mapping.	Unconnected
Run a stored procedure once during a mapping.	Unconnected
Run a stored procedure every time a row passes through the SQL transformation.	Connected or unconnected
Run a stored procedure based on data that passes through the mapping such as when a specific field does not contain a null value.	Unconnected
Pass parameters to the stored procedure and receive a single output parameter.	Connected or unconnected
Pass parameters to the stored procedure and receive multiple output parameters. To get multiple output parameters from an unconnected SQL transformation, you must create variables for each output parameter.	Connected or unconnected
Run nested stored procedures.	Unconnected
Call a stored procedure multiple times within a mapping.	Unconnected