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

Hands-On Microsoft SQL Server 2008 Integration Services part 33. 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. . | 298 Hands-On Microsoft SQL Server 2008 Integration Services Figure 8-2 Enabling events to log 13. Expand the Iterating October Opportunities container and select the Mailing Opportunities task. Note that the events on the Details tab remain the same as the logging options have been inherited from the parent. Click twice on the check box to the left of Mailing Opportunities to place a highlighted tick in the check box and change the LoggingMode to Enabled for this task. As you do that you will notice that three new events SendMailTaskBegin SendMailTaskEnd and SendMailTaskInfo have been added to the list in the Details pane. These are the custom log entries provided by the SMTP task as you know many of the Integration Services objects provide custom log entries for logging specific information related to their functionality only. 14. Click Advanced and you will see the information fields that will be logged when the selected events occur. These log schema fields have been described earlier in this chapter. Select the OnProgress SendMailTaskBegin SendMailTaskEnd and SendMailTaskInfo events only as shown in Figure 8-3. Note that all the fields of log schema are selected by default. 15. Go to Providers and Logs tab. Select the check box for SMTP task level log to Text file as you want to log events to a text file for Mailing Opportunities Task. Click OK to close the Configure SSIS Logs dialog box. You ve successfully configured logging for this package. Chapter 8 Advanced Features of Integration Services 299 Figure 8-3 Configuring unique log entries for the Mailing Opportunities task Exercise Analyze Integration Services Logs Finally let us execute the package to record logs entries and check them using SQL Server Management Studio. 16. Press the F5 key to execute the package. You will see the components changing color from yellow to green. When the package execution completes press shift-f5 to return to design mode. 17. Run SQL Server Management Studio and connect to .