Hands-On Microsoft SQL Server 2008 Integration Services part 25. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 218 Hands-On Microsoft SQL Server 2008 Integration Services Figure 5-35 Configuration options for the Maintenance Cleanup task Notify Operator Task The Notify Operator task sends notification messages to SQL Server Agent operators. For this task to work properly you need to have the SQL Server Agent service working and for this task to show you the list of operators you need to have operators defined in the SQL Server Agent and assign them an e-mail address. This task lists only users that have an e-mail address associated with them. Chapter 5 Integration Services Control Flow Tasks 219 Following is the step-by-step method to configure this task 1. Specify an SqlClient Data Provider Connection Manager in the Connection field. If you do not have any operator configured with an e-mail address to which you are trying to connect you will receive the error message There are no operators with e-mail addresses defined on this server. You can configure operators using SQL Server Management Studio. 2. Select the operators you want to notify from the list as shown in Figure 5-36 under the Operators To Notify area. 3. Type in the subject and the message you want to send in the provided fields and click OK to complete the configuration. Figure 5-36 User Interface for the Notify Operator task 220 Hands-On Microsoft SQL Server 2008 Integration Services Rebuild Index Task When you insert update or delete records from tables the indexes become fragmented and the performance suffers. To keep the performance at the optimal level you may decide to rebuild indexes as part of your SSIS package. The Rebuild Index task drops the index and creates a new one using the specified fill factor for SQL Server database tables and views. By rebuilding the index this task removes fragmentation of pages compacts the tables reclaims disk space and orders the rows in the contiguous pages thus improving performance. This task effectively runs the ALTER INDEX REBUILD T-SQL command. Here is the
