Steps to Manage SSIS Packages

1.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."

2.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.

3.Configure a task:
In BIDS, double-click the task to open its editor, and then make the configuration changes.

4.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.

5.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.

6.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.

7.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.

8.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.