Copying the Lesson 3 Package

In this task, you will create a copy of the Lesson 3.dtsx package that you created in Lesson 3. Alternatively, you can add the completed lesson 3 package that is included with the tutorial to the project, and then copy it instead. You will use this new copy throughout the rest of Lesson 4.

Because package configuration information is copied along with the package itself, you must also modify the package configuration to reverse one of the changes made in the preceding lesson, and point the Foreach Loop back to the original Sample Data folder.

To create the Lesson 4 package

1. If Business Intelligence Development Studio is not already open, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click Business Intelligence Development Studio.

2. On the File menu, click Open, click Project/Solution, select SSIS Tutorial and click Open, and then double-click SSIS Tutorial.sln.

3. In Solution Explorer, right-click Lesson 3.dtsx, and then click Copy.

4. In Solution Explorer, right-click SSIS Packages, and then click Paste.

   By default, the copied package is named Lesson 4.dtsx.

5. In Solution Explorer, double-click Lesson 4.dtsx to open the package.

6. Right-click anywhere in the background of the Control Flow tab and click Properties.

7. In the Properties window, update the Name property to Lesson 4.

8. Click the box for the ID property, and then in the list, click <Generate New ID>.

To add the completed Lesson 3 package

1. Open Business Intelligence Development Studio and open the SSIS Tutorial project.

2. In Solution Explorer, right-click SSIS Packages, and click Add Existing Package.

3. In the Add Copy of Existing Package dialog box, in Package location, select File system.

4. Click the browse (…) button, navigate to C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\ Tutorial\ Creating a Simple ETL package\Completed Packages, select Lesson 3.dtsx, and then click Open.

5. Copy and paste the Lesson 3 package as described in steps 3-8 in the previous procedure.

To modify the package configuration

1. In Notepad or any other text editor, locate and open the SSISTutorial.dtsConfig configuration file that you created by using the Package Configuration Wizard in the previous lesson. If you are starting from this lesson and did not create a configuration file, you can use the configuration file located in the folder c:\Program Files\SQL Server\90\Samples\Integration Services/Tutorial/Creating a Simple ETL Package\Completed Packages.

2. Change the value of the ConfiguredValue element back to the original sample data folder. By default, the sample data is installed to the c:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data folder. If you are starting from this lesson and did not modify this file earlier, you do not need to make any changes.

   Note

   You do not need to surround the path with quotes in the XML configuration file.

3. Save the change, and then close the text editor.

Next Task in Lesson

Adding and Configuring Logging

Change History