Throughout this book, you’ve been exposed to different ways to manage the development and administration of SSIS packages using the Visual Studio IDE and SQL Server Management Studio. This chapter expands on those operations by providing an overview of the ways in which you perform these same management and administrative functions programmatically through managed code. You learn how to use the
Parameter classes that have been added to the
Microsoft.SqlServer.Dts.Runtime class, as well as the
Microsoft.SqlServer.Management.IntegrationServices class also known as the Managed Object Model. You will also learn how to perform legacy package management operations using the managed
Package classes exposed in the dynamic-linked library
Microsoft.SQLServer.ManagedDTS.dll by the .NET
The second half of this chapter details the capabilities of the WMI Data Reader Task and the WMI Event Watcher Task. These tasks provide access to system information via the Windows Management Interface model, better known as WMI. Through a query-based ...