Ads 468x60px

Wednesday, September 21, 2011

Learn SSIS : Expressions in SSIS - Part 2




In my previous post i covered Event handler, in this i will be covering Expressions, and where we can actually set the expressions to extend SSIS package functionality.

Wednesday, September 14, 2011

Learn SSIS : Event handlers, variables, expressions in SSIS - Part 1




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

Tuesday, September 13, 2011

Learn SSIS : Contol flow task categorization





Like how we categorized data flow transformations in my previous post "Dataflow-transformation-categorization" here i have categorized various control flow tasks we have in SSIS.

The task have been categroized based on the functionality they provide in SSIS Control Flow.