ASP.NET 2.0 Interface for SSIS

Hi there,

we have several DWH Load processes running in SSIS, however I want to enable the enduser to have more control and information about the status of these processes. Therefore I plan to write a monitoring interface based on ASP.NET 2.0. However I hardly could find good docu or samples on what is available from within ASP.NET 2.0 to read out or control SSIS.

Anybody having me some good pointers to start with ?

To control Ssis packages programmatically start with the Microsoft.SqlServer.ManagedDTS assembly, (Microsoft.SQLServer.ManagedDTS.dll). For the more monitoring type functions, I don’t think there is anything specific, but I’d suggest you look at the logging built into SSIS, set this on in your packages, and query the destination log.

There is also the SSIS service, but not sure if there is a way of communicating with that, other than basic service APIs, and/or WMI.

|||Application class in Microsoft.SqlServer.Dts.Runtime namespace (Microsoft.SQLServer.ManagedDTS.dll assembly) provides some ability to interact with service and monitor/manage running packages. In particular, see
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.getrunningpackages.aspx
method.

Together with SSIS logging this should provide the API you need.