Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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)

public function GetRunningPackages(
	server : String
) : RunningPackages


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.

No code example is currently available or this language may not be supported.

Community Additions

© 2015 Microsoft