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

Hands-On Microsoft SQL Server 2008 Integration Services part 61. 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. . | 578 Hands-On Microsoft SQL Server 2008 Integration Services read the configuration file path from an environment variable. So when you deploy the package the configuration file is available to the package via the environment variable. When you create an indirect configuration for an XML configuration file instead of specifying the file path directly you point your package to read the file path for the XML configuration file from an environment variable. The computer-specific XML configuration file defines the environment on the deployment computer. Once you have created such XML configuration files for each computer the package deployment gets reduced to copying your package to these computers. For still more complex environments you can update the variable values in the package during run time using configurations and the variables in turn modify properties of the package through the use of property expressions. In this way you can have a totally disjointed configuration for your package with different bits playing their roles independently of each other yet in a coordinated way. The concept of indirect configurations may seem complex but in reality is simple to adapt and use quite interestingly we already use this concept in real life. Think of your car as a package that has properties such as steering wheel position pressure on the brake pedal and so on. These properties change the behavior of the package the car in our analogy. You the driver are modifying these properties that are analogous to property expressions. To modify the properties of car you are guided by the road conditions variable values in package analogy such as traffic lights or traffic signs. And above all these road conditions are regulated and applied by a traffic regulating agency which is the configuration file in our package. So the package configuration sets the environment traffic lights the environment changes the variable values traffic light turning green and using those modified .

TÀI LIỆU LIÊN QUAN
TỪ KHÓA LIÊN QUAN
crossorigin="anonymous">
Đã 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.