One of the most common ways to debug ETL errors in SSIS is to use breakpoints and debug windows. Breakpoints allow you to pause the execution of a package or a task at a specified point and ...

You'll wonder no more how to manipulate SSIS Package Variables via Script Tasks, once you're done reading this little tidbit.