Installing and Compiling Integration Services Programming Samples

All Microsoft SQL Server 2005 Integration Services (SSIS) code samples can be installed onto the local hard disk drive by using a stand-alone Windows Installer application that is installed as an option during SQL Server 2005 setup. After the samples are installed, you can compile them at the command prompt, or by using the IDE in Microsoft Visual Studio .NET.


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.

For more information about installing samples, see "Installing Samples" Installing Samples. To obtain the latest version of the samples, including new samples released since the original release of SQL Server 2005, see SQL Server 2005 Samples and Sample Databases (April 2006).

To Install Integration Services Code Samples using the Standalone Installer

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Documentation and Tutorials, point to Samples, and then click Microsoft SQL Server 2005 Samples.

  2. When the Microsoft SQL Server 2005 Samples - InstallShield Wizard welcome page appears, select Next.

  3. If you agree to the terms of the license agreement, select I accept the terms in the license agreement and then click Next.

  4. By default, the Integration Services samples are installed onto the local hard disk drive in the following folder: C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\\Programming Samples\. Click Next.


    It is recommended that the default installation location of the samples be used. If a location other than the default is used, you may have to manually modify sample contents to reflect this change.

  5. To confirm the installation of the samples, click Next.

  6. After the installation of the samples is complete, click Close.

To Build the Sample

  1. The first steps require running executables at a Visual Studio command prompt. Click Start / All Programs / Microsoft Visual Studio 2005 / Visual Studio Tools / Visual Studio 2005 Command Prompt. Run the following command prompt to create a strong-name key pair:

    sn -k <sample path>\keypair.snk
  2. Copy the signature file (keypair.snk) to the one that would contain only a public key:

    sn -p <sample path>\keypair.snk publicKeyPair.snk


    For more information on the strong-name key pair, see "Security Briefs: Strong Names and Security in the .NET Framework" in the .NET Development Center on MSDN.

  3. Open Visual Studio.

  4. From the File | Open menu, click Project and open the solution (.sln) for the desired sample from the CS or VB folders, depending on the language you want.

  5. Build the project by selecting Build / Build <projectname> from the menu to build a DLL, or press F5 to build and run the sample and see output.

See the Readme for each sample for specific instructions on how to build or compile each sample, as instructions may vary.

The executable is put in a new folder named bin\debug that is relative to the default directory of the sample. For example, compiling the ADO Source Component Sample will put the resulting executable in this folder:

C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\\Programming Samples\Data Flow\ADO Source Component Sample\<language>\ADO Source Component Sample\bin\Debug.


Some samples have additional steps that must be performed before compiling. These requirements are listed in the topic that discusses that sample.

Change History

Release History

17 July 2006

Changed content:
  • Provided link to site where new samples are available for download.