MS SSIS

Data Flow ✘ Execute SQL ✘ File System ✘ ActiveX Script ✔

Output column ✘ Length ✘ Scale ✘ Precision ✔

Remove a column ✘ Replace existing column ✘ Delete column ✘ Move a column ✔

WriteExpression ✘ UnAssignExpression ✘ InitExpression ✘ ReadOnlyExpression ✔

! ✘ ? ✘ ^ ✘ * ✔

The expressions can be used ✘ The variables can be deleted ✘ The variables can be duplicated ✘ The scope of a variable can be checked ✔

Parallel ✘ Non-sequential ✘ Row number ✘ Random ✔

Process bytes ✘ Public bytes ✘ Private bytes ✘ Global bytes ✔

Package Level ✘ SSIS Task ✘ Connection Manager ✘ Project Level ✔

Select ✘ Update ✘ Delete ✘ Insert ✔