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 .
