MS SSIS Set 1

Full blocking ✘ Open blocking ✘ Partial blocking ✘ Non blocking ✔

Conditional split ✘ Multicast ✘ Script component ✘ Union all ✔

Merge join ✘ Merge ✘ Sort ✘ Data mining ✔

Fuzzy lookup ✘ Term extraction transformation ✘ Data flow task ✘ File system task ✔

SQL server ✘ Package store ✘ File system ✘ Shared drive ✔

Rowset ✘ Audit ✘ Row ✘ Split & Join ✔

For loop container ✘ For each loop container ✘ Task host Container ✘ Sequence container ✔

Reference ✘ Dimension ✘ Master ✘ Fact ✔

OnValidate ✘ OnError ✘ OnProgress ✘ OnTaskSucces ✔

Variables ✘ Parameters ✘ Package configurations ✘ Transactions ✔