Professional SQL Server™ 2005 Integration Services

16.1. External Management with Managed Code

The SSIS development team has done a terrific job in providing a robust architecture to manage SSIS through managed code. Managed code in this case refers to the use of the .Net Framework Common Language Runtime that hosts code written in C# or VB.NET.

Through a rich object model, you can customize your applications to control almost every aspect of a SSIS server instance. This section will attempt to provide a brief overview of the SSIS programming model as it applies to externally managing a SSIS server instance and the SSIS packages it contains.

To start using these objects exposed by the Microsoft.SqlServer.Dts.Runtime namespace, you must first have created a project in Visual Studio 2005. If you are unfamiliar with how to do this, the example presented later in this chapter will walk you through the creation of a simple Web page that utilizes these operations. But for now, I will generally describe the functionality available through code snippets. If you are unfamiliar with C#, I would suggest you investigate the language to fully understand these code snippets and how the example works.

The classes in this namespace are encapsulated by the Microsoft.SQLServer.ManagedDTS class library. Add this reference to a new console application and investigate the classes exposed for your use. Pay particular attention to the members exposed by the Application and Package objects. These are the core objects you will be working with.

The Application ...