TAILIEUCHUNG - 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 .

TÀI LIỆU LIÊN QUAN
TỪ KHÓA LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.