Readme_Installing and Compiling Integration Services Programming Samples
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
- Follow the installation instructions described in the topic, Considerations for Installing SQL Server Samples and Sample Databases.
To build the code samples
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
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.
Open Visual Studio.
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.
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.