Hi
i am curious when to use script task where other components in ssis can't do the job
Well there is your answer! 😉
One example would be to obtain the error message for a column that was redirected on error (not fail package) , by default SSIS provides the error number but in order to get to the text of the associated error you need a script task..
Its one that I have used quite a bit.
Here is an example
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe