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.

If you decide to update the stored procedure, you must do so in the following order.
Note: If it is not done in this order, the cache entry will reflect that of the previous stored procedure.

Procedure

  1. Update the stored procedure in the database.
  2. Update and deploy the process using the stored procedure.