A Custom SQL transformation task lets you write, edit, or import a SQL script or batches of scripts that perform a custom transformation.
Instead of modeling, you can use a SQL script to describe a transformation. You can use a Custom SQL task to model uncommon or extremely complex transformation types.