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)

'Declaration
Public Function GetRunningPackages ( _
	server As String _
) As RunningPackages
'Usage
Dim instance As Application
Dim server As String
Dim returnValue As RunningPackages

returnValue = instance.GetRunningPackages(server)

Parameters

server
Type: System.String
The instance of SQL Server that the application is running on.

Return Value

Type: Microsoft.SqlServer.Dts.Runtime.RunningPackages
A RunningPackages collection that contains the RunningPackage objects that represent all the packages that are currently executing on the computer.

Administrators see all packages that are currently running on the computer; other users see only those packages that they have started.

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.
Dim app As New Application
'...
' Create a RunningPackages collection, named pkgs, and fill it
' with the running packages from the application object.
Dim pkgs As RunningPackages = app.GetRunningPackages(Nothing) 
 
' Enumerate over each package in the collection and display some data.
For Each package As RunningPackage In pkgs
        Console.WriteLine("InstanceID: " & package.InstanceID.ToString())
        Console.WriteLine("PackageDescription: " & +package.PackageDescription)
        Console.WriteLine("PackageID: " & package.PackageID.ToString())
        Console.WriteLine("PackageName: " & package.PackageName)
        Console.WriteLine("UserName: " & package.UserName)
Next
'   Insert more code here.

Community Additions

ADD
Show: