Đang chuẩn bị liên kết để tải về tài liệu:
Hands-On Microsoft SQL Server 2008 Integration Services part 36

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

Hands-On Microsoft SQL Server 2008 Integration Services part 36. 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. . | 328 Hands-On Microsoft SQL Server 2008 Integration Services Review Event Handlers are like subpackages that can respond to events occurring at run time and if properly designed and developed they can let you have a good night s sleep most nights. In this exercise you created simple event handlers for OnTaskFailed and OnPostExecute events and have seen how these event handlers wake up on the occurrence of these events and perform the work they are configured to perform. You can create quite a complex event handler to perform alternative actions if a particular event happens. However you also need to be careful while using these event handlers as the events are flagged up to the parent container at the cost of CPU cycles unless you filter out the events not to be sent to parent container. Last you can disable event handlers during design and testing using the DisableEventHandlers property on the objects on which the event handlers have been defined. As a Data Source for Reporting Services Report This is an excellent feature that allows you to use an SSIS package as a data source inside a reporting services report. You will study about a DataReader Destination of Data Flow task in Chapter 9 that can act as a data source for external applications. The Data Reader Destination is not actually a destination to write data to some data store rather it is an interface for ASP.NET applications to connect and read data from an SSIS package. This feature is not enabled by default in Reporting Services so you have to enable it before using it. The following describes the steps you need to perform. Enable SSIS as a Data Source To enable SSIS as a data source you need to configure two reporting services config files RSReportDesigner.Config and RSReportServer.Config files. 1. First locate the RSReportDesigner.Config file which exists in the C Program Files Microsoft Visual Studio 9.0 Common7 IDE PrivateAssemblies folder in a default installation. 2. Open this file using either any