tailieunhanh - Hands-On Microsoft SQL Server 2008 Integration Services part 23

Hands-On Microsoft SQL Server 2008 Integration Services part 23. 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. . | 198 Hands-On Microsoft SQL Server 2008 Integration Services Figure 5-21 The WMI Connection Manager configured to connect to CIMV2 3. To specify the source from where the task can access the WQL query you can choose from the Direct input File connection or Variable options. Leave the Direct Input option selected in the WqlQuerySourceType field. 4. Type in the following query in the WqlQuerySource field and click OK to return to the task editor. SELECT ComputerName EventCode Logfile Message SourceName TimeGenerated Type FROM Win32_NTLogEvent WHERE Logfile Application AND SourceName SQLISPackage100 AND Type Error AND TimeGenerated 20100101 5. In the OutputType field choose Data Table. 6. In the OverwriteDestination field choose Overwrite Destination as you will be running this test package many times. However you should choose this option carefully in the production environment. 7. In the DestinationType field you can specify to write the data to a file or to a variable. Choose File Connection in this field see Figure 5-22 . 8. In the Destination field choose New Connection. and select C SSIS RawFiles as the existing file in the File Connection Manager Editor. This is a blank file used as a placeholder for Application Log data Chapter 5 Integration Services Control Flow Tasks 199 Figure 5-22 Configuring the WMI DataReader task to read an application log enclosed within the folder. If you don t find this file create a blank text file in this folder using Notepad. Click OK twice to complete the configurations. 9. Press F5 to start debugging the package. If you have not made any typos and the WQL configured is compatible with your system the task will run successfully. Explore to the C SSIS RawFiles folder and open the file you will see the contents of the Windows Application log extracted in the text format. Review In this exercise you learned how to configure and use the WMI Data Reader task. You also learned about some basic .