Hands-On Microsoft SQL Server 2008 Integration Services part 7. 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. . | 38 Hands-On Microsoft SQL Server 2008 Integration Services Figure 1-5 Connecting to the Integration Services service 6. Under the database server expand the Management node and then the Legacy node. You will see a Data Transformation Services node. This is where you will be managing DTS 2000 packages that are imported into SQL Server 2008. How you run existing DTS 2000 packages or migrate them to the Integration Services format is covered in depth in Chapter 14. 7. Close SQL Server Management. Review Though you haven t yet built anything from the development point of view you ve seen quite a lot. If you ve used DTS 2000 it may have already answered many of your questions but if you are new to SQL Server you can appreciate how easy it is to use SQL Server Management Studio to connect to Integration Services and manage SSIS packages storage locations. Also you know where you can see DTS 2000 packages imported into SQL Server 2008. However if you haven t installed the Integration Chapter 1 Introducing SQL Server Integration Services 39 Services as we did in earlier exercise or are trying to connect to an already existing Integration Services service on a remote server and run into issues you may like to refer to the section Connecting to Integration Services Service in Chapter 6 to understand the issues involved in connecting to the Integration Services service. Summary You have been introduced to Integration Services by following a couple of simple Hands-On exercises and reading a description of its architecture features and uses. You understand how various components of Integration Services work together to provide the manageability flexibility and scalability you need for your SSIS packages. You also appreciate the fact that all the components can be programmatically controlled and that custom tasks and transformations can be written using languages such as C or any CLR-compatible language. You know that Integration Services has two separate engines that provide .
