Application.GetRunningPackages Method
Returns a RunningPackages collection that contains RunningPackage objects. This property is read-only.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Parameters
- server
- Type: System.String
The instance of SQL Server that the application is running on.
Return Value
Type: Microsoft.SqlServer.Dts.Runtime.RunningPackagesA RunningPackages collection that contains the RunningPackage objects that represent all the packages that are currently executing on the computer.
The following code example shows how to retrieve the collection of running packages from the application object, and then iterate over each package, displaying the InstanceID, PackageID, PackageDescription, PackageName, and UserName.
//... // Declare and instantiate objects here. Application app = new Application(); //... // Create a RunningPackages collection, named pkgs, and fill it // with the running packages from the application object. RunningPackages pkgs = app.GetRunningPackages(null); // Enumerate over each package in the collection and display some data. foreach(RunningPackage package in pkgs) { Console.WriteLine("InstanceID: "+package.InstanceID); Console.WriteLine("PackageDescription: "+package.PackageDescription); Console.WriteLine("PackageID: "+package.PackageID); Console.WriteLine("PackageName: "+package.PackageName); Console.WriteLine("UserName: "+package.UserName); } // Insert more code here.
