Selecting a Stored Procedure
You can select a stored procedure in two ways: you can manually enter the stored procedure name, or if you have defined a database connection profile, you can select the stored procedure from the design-time target database.
- Manually Entering a Stored Procedure Name
Stored procedures names can be manually entered. - Selecting a Stored Procedure From the Database
You can select a stored procedure from the database. - Updating a Stored Procedure Used in a Database Task Activity
The Database Task Activity holds a cache of metadata for stored procedures for performance reasons. It checks for any changes in the database activity that uses the stored procedure (for example, changes in the number of input and output parameters, type changes) before using the one from cache. If there is a change, the initial cache entry is invalidated and the metadata for the stored procedure is retrieved.
Copyright © Cloud Software Group, Inc. All rights reserved.