Why we use Stored Procedure transformation?

A Stored procedure transformation is an important tool for populating and maintaining databases.

Database administrators create stored procedures to automate time consuming tasks that are too complicated for standard SQLstatements.

Stored procedures can be used to do the following tasks:

• Check the status of a target database before loading data into it.
• Determine if enough space exists in a database.
• Perform a specialised calculation.
• Drop and recreate indexes.