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

Hands-On Microsoft SQL Server 2008 Integration Services part 28. 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. . | 248 Hands-On Microsoft SQL Server 2008 Integration Services 7. Move on to the Reporting page. This page has Console events and Console logging boxes which can be configured with the numerous given options. You can use the Reporting page to set the options for the package by selecting the events and the information about the running package to report to the console. Console events specify the events and types of messages to report whereas Console logging specifies the information that you want written to the log when the selected event occurs. 8. In the Logging page you can tell the Package Execution utility which log providers to use at run time by specifying the log providers and the connection string for connecting to a log. The options for log providers are SSIS Log Provider For Windows Event Log SSIS Log Provider For XML Files SSIS Log Provider For Text Files SSIS Log Provider For SQL Server SSIS Log Provider For SQL Server Profiler Click in the field under the Log Provider column to choose from one of the available log providers. Then you can specify the connection string in the Connection String field. 9. The Set Values page is probably the one you will be using most often when you want to update property values of packages executables connections variables and log providers at run time. This useful feature makes running and testing packages easier. You can modify the property values by typing in the modified value and the path to the property. The path can be specified using a backslash before the container the period . before the property and including a collection member within the brackets. 10. In the Verification page you can set the attributes that must be met before allowing a package to run. For example you can set the attributes to run only signed packages. Other options are to verify the package for the build number package ID number or version ID number. 11. Finally the Command Line page allows you to review and optionally edit the command see .