共用方式為

RunningPackage.InstanceID Property

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Dts.Runtime
Assembly:
Microsoft.SqlServer.ManagedDTS.dll

Returns the unique ID associated with this instance of the running object. This field is read-only.

public:
 property Guid InstanceID { Guid get(); };
public Guid InstanceID { get; }
member this.InstanceID : Guid
Public ReadOnly Property InstanceID As Guid

Property Value

Guid

Returns a GUID.

Examples

The following example shows how to retrieve the collection of running packages from the Application object and iterate over each package, displaying the InstanceID, PackageID, PackageDescription, PackageName, and UserName.

//...Declare and instantiate objects.  
//  
// Create a RunningPackages collection, pkgs, and fill it  
// with the running packages from the application object.  
RunningPackages pkgs = app.GetRunningPackages("yourserver");  
// Enumerate through 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);  
    }  
//   more code here...  

'...Declare and instantiate objects.  
'  
' Create a RunningPackages collection, pkgs, and fill it  
' with the running packages from the application object.  
Dim pkgs As RunningPackages =  app.GetRunningPackages("yourserver")   
' Enumerate through each package in the collection and display some data.  
Dim package As RunningPackage  
For Each 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)  
Next  
'   more code here...

Applies to