Double-click the package that contains the script in which you want to set breakpoints. To open the Script task, click the Control Flow tab, and then double-click the Script task.

Raising Events in the Script Task [!INCLUDE sqlserver-ssis] Events provide a way to report errors, warnings, and other information, such as task progress or status, to the containing package. The ...

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

One of the easiest is via the FTP Task. By Eric Johnson 05/17/2010 When designing SSIS packages, you will find that you often have to pull data from many different sources.