Hands-On Microsoft SQL Server 2008 Integration Services part 6. 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. . | 28 Hands-On Microsoft SQL Server 2008 Integration Services log information are moved to Integration Services 2008 format and existing tables are removed after the upgrade. There are more things for you to do while upgrading that are discussed in detail in Chapter 14. Upgrading Data Transformation Services to Integration Services 2008 is not that straightforward though SQL Server 2008 provides tools to upgrade. This is due to major differences in the architecture of DTS 2000 and Integration Services. Chapter 14 discusses all the options that you have for upgrading your existing DTS 2000 packages to Integration Services. Business Intelligence Development Studio Business Intelligence Development Studio is designed for developing business intelligence solutions including Integration Services packages Reporting Services reports and Analysis Services cubes and OLAP databases. BIDS is built on Visual Studio 2008 which allows you to design build test execute deploy and extend Integration Services packages in an integrated development environment. Because of Visual Studio 2008 integration BIDS provides the advantage of having integrated development features a debugger integrated help and an integrated source control such as Visual Studio Team Foundation Server or Visual SourceSafe environment. You can use the same techniques to develop and store Analysis Services Reporting Services and Integration Services projects with BIDS. You can also develop a solution using BIDS that can have multiple Integration Services Analysis Services and Reporting Services projects. BIDS is based on usual application design philosophy of solutions and projects. This provides lots of benefits including the following You don t need to have an SQL Server to develop an Integration Services package as was the case with DTS 2000 which required SQL Server 2000 Enterprise Manager to design and develop a package. Integration Services development and execution environments are fairly independent from the
