SSIS is not just about control flows and dataflows, there are other options available in SSIS which extends functionality of SSIS package, and provides a great flexibility in desiging a successfull ETL solution. Lets take a deep insight of what are those options and how we can take benefit of them.
There are four options which extends functionality of SSIS packages.
1. Event Handlers
2. Variables
3. Expressions
4. SQL Queries
