Readme_Installing and Compiling Integration Services Programming Samples

  • Article

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.

All Microsoft SQL Server Integration Services code samples must be installed first onto your local computer. After you install the samples on your computer, you must compile them at the command prompt, or by using the IDE in Microsoft Visual Studio.

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.

To install Integration Services code samples on your computer

To build the code samples

  1. Run the executables at a Visual Studio command prompt. Click Start / All Programs / Microsoft Visual Studio 2008 / Visual Studio Tools / Visual Studio 2008 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

    Important

    For more information about 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

    Note

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