TAILIEUCHUNG - Hands-On Microsoft SQL Server 2008 Integration Services part 10

Hands-On Microsoft SQL Server 2008 Integration Services part 10. 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. . | 68 Hands-On Microsoft SQL Server 2008 Integration Services Figure 2-14 Column Length Distribution Profiles Summary You created an Integration Services blank project in Chapter 1. In this chapter you created packages using the SQL Server Import and Export Wizard and then added those packages into your blank project. You also created a package directly in the BIDS again using the SQL Server Import and Export Wizard. But above all you explored those packages by opening component properties and configurations and now hopefully you better understand the constitution of an Integration Services package. Last you worked with the Data Profiling Task to identify quality issues with your data. In the next chapter you will learn about the basic components the nuts and bolts of Integration Services packages before jumping in to make complex packages in Chapter 4 using various preconfigured components provided in BIDS. Chapter 3 Nuts and Bolts of the SSIS Workflow In This Chapter Integration Services Objects Solutions and Projects File Formats Connection Managers Data Sources and Data Source Views SSIS Variables Precedence Constraints Integration Services Expressions Summary 70 Hands-On Microsoft SQL Server 2008 Integration Services So far you have moved data using the SQL Server Import and Export Wizard and viewed the packages created by opening them in the Business Intelligence Development Studio BIDS . In this chapter you will extend your learning by understanding the nuts and bolts of Integration Services such as use of variables connection managers precedence constraints and SSIS Expressions. If you have used Data Transformation Services DTS 2000 you may grasp these issues quickly however there is a lot of new stuff about them in Integration Services. Usability and management of variables have been greatly enhanced connectivity needs for packages are now satisfied by connection managers enhanced precedence constraints have been included to provide you total control on the .

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.