Hands-On Microsoft SQL Server 2008 Integration Services part 63. 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. . | 598 Hands-On Microsoft SQL Server 2008 Integration Services Figure 14-1 Starting installation of the Upgrade Advisor 5. Type or select an Instance Name from the drop-down list box in the Connection Parameters screen. Specify the authentication details for the selected instance and click Next when ready. Don t get confused between versions of SQL Server. The Upgrade Advisor connects to SQL Server 2000 to analyze and report so specify an instance of SQL Server 2000 here. 6. On the DTS Parameters screen you can select whether you want to analyze DTS 2000 packages that are saved in the SQL Server or the packages saved on the file system. Select the Analyze DTS Package Files radio button and then type C SSIS RawFiles in the Path To DTS Packages field. Click Next to move on. 7. Review the settings in the Confirm Upgrade Advisor Settings screen. Click Run to analyze the selected package. 8. In the next screen the Upgrade Advisor will analyze the package when it completes analysis you can see the report by clicking Launch Report. The Chapter 14 Migrating to Integration Services 2008 599 Figure 14-2 Selecting Data Transformation Services for analysis analysis report will be displayed in the Upgrade Advisor Report Viewer. The key messages that you can spot in the report among other messages are That you need to install SQL Server 2000 DTS Designer Components to edit the packages in Integration Services. Packages stored in Meta Data Services are not supported. SQL Server 2000 Data Transformation Services has been deprecated. Review Depending on the complexity and the components used in the package you will see different messages for your packages. But you will find that the previously mentioned three key messages are common to all types of packages as these are generic messages representing major differences between DTS and SSIS. 600 Hands-On Microsoft SQL Server 2008 Integration Services Migrating Data Transformation Services Packages In this part of the chapter you will .
