Chapter 9 Quick Reference

Open table as spreadsheet

To	Do This
Create an OnPreExecute event handler	In BIDS, on the Event Handlers tab, in the Executable drop-down list, select NewProducts, and then click OK. In the Event Handler drop-down list, select OnPreExecute. In the Event Handlers design environment, click the blue text that reads "Click here to create an OnPreExecute event handler for executable NewProducts."
Add a task to an event handler	In BIDS, while on the Event Handlers tab, click Toolbox, and then drag the event handler onto the design environment.
Configure a task	In BIDS, double-click the task to open its editor, and then make the configuration changes.
Map SSIS variables to SQL statement parameters	In BIDS, on the Control Flow tab, double-click the SQL task to open its editor. In the Execute SQL Task Editor, click Parameter Mapping, click Add, and then configure the variable.
Create a file system task and a connection manager	In BIDS, while on the Event Handlers tab, click Toolbox, and then drag File System Task onto the designer. Double-click the task and, in the File System Task Editor, type the name, destination connection, and source connection.
Set connection manager settings	In BIDS, in the Connection Managers pane, right-click the connection manager, and then click Properties. In the Properties list, expand Expressions, and then click the ellipses button. In the Property Expressions Editor, change the settings.
Prevent events from escalating to a container	In BIDS, while on the Event Handlers tab, on the SSIS menu, click Variables. In the Variables list, in the Value column drop-down list, change the value.
Change error count properties	In BIDS, on the Control Flow tab, right-click on the design surface, and then click Properties. In the Properties list, locate MaximumErrorCount, and then change the value.