You can configure the SQL transformation to process a stored procedure or stored function on the
tab of the SQL transformation.
panel of the SQL transformation, click the
Select the connection to the database.
You can select the connection or use a parameter.
If you want to parameterize the connection, create the parameter after you select the stored procedure or function.
Set the SQL type to
to select the stored procedure or function from the database, or enter the exact name of the stored procedure or function to call.
The stored procedure or function name is case-sensitive.
If you add a new stored procedure to the database while you have the mapping open, the new stored procedure does not appear in the list of available stored procedures. To refresh the list, close and reopen the mapping.
If the transformation processes a stored procedure and you want to run the transformation in unconnected mode, select
Unconnected Stored Procedure
If you want to parameterize the connection, click
and enter the details for the connection parameter.