Deploying Packages Tutorial: Lesson Packages

  • Article

New: 14 April 2006

The LoadXMLData and DataTransfer packages are the packages that you enhance and deploy in the Integration Services tutorial, Deploying Packages. The topics in Books Online provide detailed information about the functionality of each package. For more information, see the topics in "Deploying Packages Tutorial" located in the Integration Services Tutorials section of Books Online.

You can open and run these packages outside the tutorial. However, we do not recommend that you modify them. If you use modified packages in the tutorial, the lesson results may be different from those described in the tutorial.

The following table provides a brief summary of each package.

Package Description

DataTransfer

A simple package that extracts data from a single flat file, splits the extracted dataset based on column values, and loads the resultant data into a table in the AdventureWorks database. If the table does not already exist, the package creates it.

The Execute SQL task in the package logs events to an XML log file.

LoadXMLData

A simple package that extracts data from an XML data file, splits the extracted dataset based on column values, aggregates values, and loads the resultant data into a table in the AdventureWorks database. If the table does not already exist, the package creates it.

Important

Samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples.

Requirements

Running this sample package requires the following:

  • The sample packages and data files that it uses must be installed on the local hard disk drive.
  • You must have installed and have administrative permissions on the AdventureWorks database.
  • If you intend only to run the sample package from the command line, you must install SQL Server 2005 Integration Services (SSIS).
  • If you intend to open the package in SSIS Designer and run the sample package, you must also install Business Intelligence Development Studio.

For more information about how to install samples, see "Installing Sample Integration Services Packages" in SQL Server 2005 Books Online. To obtain the latest version of the samples, including new samples released after the original release of SQL Server 2005, see SQL Server 2005 Samples and Sample Databases (April 2006).

Location of the Sample Packages

If the samples were installed to the default installation location, the tutorial sample packages are located in the following folder:

C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Deploying Packages\Completed Packages

Running the Sample

The packages can be run from the command line by using the dtexec utility, or can be run in Business Intelligence Development Studio.

If you are using a non-English version of Windows, you may have to update the ConnectionString property of any file connection managers used in the package to run the sample package successfully. You should verify that the path used in the connection manager is valid on your computer, and if you need to, modify the path so that it uses the localized name of the Program Files folder.

For this sample, you may have to update "Program Files" in the ConnectionString property for the NewCustomers connection manager.

To run the package by using dtexec

  1. Open a Command Prompt window.

  2. Change the directory to C:\Program Files\Microsoft SQL Server\90\DTS\Binn, the location of dtexec.

  3. Type the following command:

    dtexec /f "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Deploying Packages\Completed Packages\<package name>"

  4. Press Enter.

For more information about how to run the package by using the dtexec utility, see the topic, "dtexec Utility", in SQL Server 2005 Books Online.

Running the Sample in Business Intelligence Development Studio

If you do not already have an Integration Services project to which you can add the tutorial packages, you must first create a project.

To create a new Integration Services project

  1. Open Business Intelligence Development Studio.

  2. On the File menu, point to New, and then click Project.

  3. In the New Project dialog box, select the Integration Services Project template from the Templates pane.

  4. Optionally, edit the project name and the location. The solution name is automatically updated to match the project name.

  5. In the Solution drop-down list, select Create new Solution.

  6. To create a separate folder for the solution file, select Create directory for solution. This is the default option.

  7. Click OK to add the solution to Solution Explorer and add the project to the solution.

Next, you add the packages to the Integration Services project.

To run a package in Business Intelligence Development Studio

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

  2. In the Add Copy of Existing Package dialog box, set Package location to File system, click browse (…), and locate the folder that contains the completed packages from the tutorial. The default location is C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Deploying Packages\Completed Packages.

  3. Click the package to add, and then click Open.

  4. Click OK.

  5. Repeat steps 1-4 to add the second tutorial package to the project.

  6. Right-click the package to run in the SSIS Packages folder, and then click Execute Package.