Stored procedures can be very useful for complex calculations, lookups and validations.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions