Hands-On Microsoft SQL Server 2008 Integration Services part 65. 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. . | 618 Hands-On Microsoft SQL Server 2008 Integration Services Exercise Use the Package Migration Wizard In the first part of this Hands-on you will create a new project and run the Package Migration Wizard by right clicking the SSIS Packages node. This will not only migrate the package but will add it in the project as well. 1. Start BIDS and create a new Integration Services project with the following details Name Migrating Importing Contacts Location C SSIS Projects 2. When BIDS loads the blank project go to the Solution Explorer window rightclick the SSIS Packages node and choose Migrate DTS 2000 Package from the context menu see Figure 14-13 . 3. This will invoke the Package Migration Wizard and you will see the first screen of this wizard. Click Next to move on. 4. The Choose Source Location screen allows you to select the location where your package is stored. Click the down arrow in the Source field to see the list of source locations. The Package Migration Wizard can read DTS 2000 packages stored in Microsoft SQL Server or in a structured storage file. As mentioned SQL Server 2005 does not support Meta Data services also called the repository . If your DTS 2000 package is stored in Meta Data services you may prefer to save those packages to the locations supported by the Package Migration Wizard. In case you cannot do that the Package Migration Wizard provides a way to read packages from Meta Data services when SQL Server 2000 SQL Server 2000 tools or the repository redistributable files are installed on the local computer. For this exercise select Structured Storage File in the Source field. Figure 14-13 Starting the Package Migration Wizard Chapter 14 Migrating to Integration Services 2008 61 9 5. Specify C SSIS RawFiles Importing in the File Name field as shown in Figure 14-14. Alternatively you can choose this file by clicking Browse. Click Next to move on. 6. In the Choose Destination Location screen specify the folder where you want to save
