Share via

  • Article

Exec80PackageTask Class

Contains the members used to configure and run an Execute DTS 2000 Package task, which runs other Microsoft SQL Server 2000 Data Transformation Services (DTS) packages.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask

Namespace:  Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask
Assembly:  Microsoft.SqlServer.Exec80PackageTask (in Microsoft.SqlServer.Exec80PackageTask.dll)

Syntax

'Declaration
Public NotInheritable Class Exec80PackageTask _
    Inherits Task _
    Implements IDTSComponentPersist, IDTSExec80PackageTask, IDTSBreakpointSite, IDTSSuspend
'Usage
Dim instance As Exec80PackageTask

public sealed class Exec80PackageTask : Task, 
    IDTSComponentPersist, IDTSExec80PackageTask, IDTSBreakpointSite, IDTSSuspend

public ref class Exec80PackageTask sealed : public Task, 
    IDTSComponentPersist, IDTSExec80PackageTask, IDTSBreakpointSite, IDTSSuspend

[<SealedAttribute>]
type Exec80PackageTask =  
    class
        inherit Task
        interface IDTSComponentPersist
        interface IDTSExec80PackageTask
        interface IDTSBreakpointSite
        interface IDTSSuspend
    end

public final class Exec80PackageTask extends Task implements IDTSComponentPersist, IDTSExec80PackageTask, IDTSBreakpointSite, IDTSSuspend

The Exec80PackageTask type exposes the following members.

Constructors

  Name Description
Public method Exec80PackageTask Initializes a new instance of the Exec80PackageTask class.

Top

Properties

  Name Description
Public property DebugMode Gets or sets a Boolean that indicates whether Exec80PackageTask should check if breakpoints are enabled.
Public property DTS2000Package Contains the DTS 2000 package. The package is embedded in the task and stored; there is no external file containing the package.
Public property ExecutionValue Returns a user-defined object. This field is read-only. (Inherited from Task.)
Public property Filename Gets or sets the full path and file name of the structured storage file that contains the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property InnerGlobalVariables Gets or sets a VariablesCollection object that contains global variables that represent the inner variables of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property Location Gets or sets a Exec80PackageTask.Locations value that indicates the type of storage in which the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by a Exec80PackageTask is located.
Public property OuterGlobalVariables Gets or sets a VariablesCollection object that contains global variables that represent the outer variables of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property PackageID Gets or sets the globally unique identifier (GUID) for the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property PackageName Gets or sets the name of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property PackagePassword Gets or sets the package password for the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property PackageVersionGUID Gets or sets the globally unique identifier (GUID) for the version of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property SQLPassword Gets or sets the password of the SQL Server login to be used by the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property SQLServer Gets or sets the name of the Microsoft SQL Server 2000 instance that contains the Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property SQLUsername Gets or sets the name of the SQL Server login to be used by the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public property SuspendRequired Gets or sets a Boolean that indicates if tasks should suspend when they encounter a breakpoint. This value is set by the runtime engine for tasks and containers when a breakpoint is encountered.
Public property Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Inherited from Task.)
Public property WindowsAuthentication Gets or sets a Boolean that indicates whether the Exec80PackageTask should use Windows Authentication when executing the child Microsoft SQL Server 2000 Data Transformation Services (DTS) package.

Top

Methods

  Name Description
Public method AcceptBreakpointManager Passes a BreakpointManager reference to the Exec80PackageTask task. This method is called by the runtime and is not used in code.
Public method CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task.)
Public method ClearEmbeddedPackage Removes the stored DTS 2000 package.
Public method EmbedPackage(Package) Embeds the package inside of the Exec80PackageTask.
Public method EmbedPackage(array<Byte[]) Embeds the package inside of the Exec80PackageTask.
Public method EmbedPackage(String, String, String, Int32, Boolean, String, String, String, String) Embeds the package inside of the Exec80PackageTask.
Public method Equals Determines whether two object instances are equal. (Inherited from DtsObject.)
Public method Execute Runs the task. (Overrides Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Protected method Finalize (Inherited from Object.)
Public method GetConnectionID Gets a String containing the ID of the connection. (Inherited from Task.)
Public method GetConnectionName Gets a String containing the name of the connection. (Inherited from Task.)
Public method GetHashCode Returns the hash code for this instance. (Inherited from DtsObject.)
Public method GetPackagePassword Returns the package password.
Public method GetSqlPassword Returns the SQL Server password.
Public method GetType (Inherited from Object.)
Public method InitializeTask Initializes the properties associated with the Exec80PackageTask task. This method is called by the runtime and is not used in code. (Overrides Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)
Public method LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Public method LoadPackage Loads a package.
Protected method MemberwiseClone (Inherited from Object.)
Public method ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the runtime engine.
Public method SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Public method SuspendExecution Called when the executable needs to suspend. This method is called by the runtime engine.
Public method ToString (Inherited from Object.)
Public method Update *** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (Inherited from Task.)
Public method Validate Verifies that the Exec80PackageTask is properly configured. (Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)

Top

Fields

  Name Description
Public field Variables Gets or sets the Variables object for the Exec80PackageTask task.

Top

Remarks

For more information about the features of this task, see Execute DTS 2000 Package Task.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.