Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Step 1: Copying the Lesson 2 Package

In this task, you will create a copy of the Lesson 2.dtsx package that you created in Lesson 2. Alternatively, you can add the completed lesson 2 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 3.

To create the Lesson 2 package

  1. If Business Intelligence Development Studio is not already open, click Start, point to All Programs, point to Microsoft SQL Server, 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 2.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 3.dtsx.

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

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

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

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

To add the completed Lesson 2 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\100\Samples\Integration Services\ Tutorial\ Creating a Simple ETL package\Completed Packages, select Lesson 2.dtsx, and then click Open.

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

Community Additions

© 2015 Microsoft