• I use Script Tasks so I can have access to .NET to do things that are not built into SSIS (e.g. FileSystemWatcher class) or maybe are built into SSIS but are not easily consumable (e.g. the Execute Process Task can be cumbersome to configure if you have a lot of or have cryptic command-line parameters).

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato