12th Day

Conditional statement in SSIS: same as ternary operator in C

** <condition>? <true>:<false>

Eg: Gender=="M" ? "Male": "Female"

Multicast Transformation: This t/r creates multiple copies of i/p data. it is useful because every time we need not to go to source.

** This will improve task performance.

Aggregate Transformation: It is used to convert the detailed values into aggregated data by using Aggregate functions like sum,avg,max,min,count etc.

** It is Asynchronous transformation.

Example: to the i/p data from source group by deptno and perform aggregate funcs.

Conversion in SSIS;

* Conversion is very important because data from flat file, excel comes to transformations in the form of string(varchar) , so we cannot perform required operations so it require to convert data.

1) Directly at source level:

** Select flat file source, right click--> show advanced editor.

** Select i/p & o/p properties tab, expand flat file source o/p and expand o/p columns.

** Now select o/p column and in the properties window set the data type to required data type.

2) Using type casting functions in the t/r 's like conditional split and derived column:

Eg: (DT_I4)[Sal]*0.1