Task 1: Copying the Lesson 1 Basic Package

In this task, you will create a copy of the package that you created in Lesson 1, named Basic Package Lesson 1.dtsx. If you did not complete Lesson 1, you can add the completed Lesson 1 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 2.

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, click the SQL Server Import and Export Wizard Tutorial folder and click Open, and then double-click SQL Server Import and Export Wizard Tutorial.sln.

  3. In Solution Explorer, right-click Basic PackageLesson 1.dtsx, and then click Copy.

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

    By default, the copied package will be named Basic Package Lesson2.dtsx.

  5. In Solution Explorer, double-click Basic PackageLesson 2.dtsx to open the package.

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

  7. In the Properties window, update the Name property to Basic Package Lesson 2.

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

To add the completed Lesson 1 package

  1. Open Business Intelligence Development Studio and open the SQL Server Import and Export Wizard 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 Basic Package\Completed Packages, select Basic Package Lesson 1.dtsx, and then click Open.

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

Task 2: Updating the Execute SQL Task

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Community Additions