Application.GetRunningPackages(String) Metode

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Mengembalikan koleksi yang RunningPackages berisi RunningPackage objek. Properti ini bersifat hanya baca.

public:
 Microsoft::SqlServer::Dts::Runtime::RunningPackages ^ GetRunningPackages(System::String ^ server);

public Microsoft.SqlServer.Dts.Runtime.RunningPackages GetRunningPackages (string server);

member this.GetRunningPackages : string -> Microsoft.SqlServer.Dts.Runtime.RunningPackages

Public Function GetRunningPackages (server As String) As RunningPackages

Parameter

server

String

Instans SQL Server yang dijalankan aplikasi.

Mengembalikan

RunningPackages

Koleksi RunningPackages yang berisi RunningPackage objek yang mewakili semua paket yang saat ini dijalankan di komputer.

Contoh

Contoh kode berikut menunjukkan cara mengambil koleksi paket yang berjalan dari objek aplikasi, lalu melakukan iterasi pada setiap paket, menampilkan InstanceID, , PackageIDPackageDescription, PackageName, dan 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.  

'...  
'   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.  

Keterangan

Administrator melihat semua paket yang saat ini berjalan di komputer; pengguna lain hanya melihat paket yang telah mereka mulai.