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 SQL

statements.

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.