Exec80PackageTask Members

  • Article

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.

The following tables list the members exposed by the Exec80PackageTask type.

Public Constructors

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

Top

Public Fields

  Name Description
ms214667.pubfield(en-US,SQL.90).gif Variables Gets or sets the Variables object for the Exec80PackageTask task.

Top

Public Properties

  Name Description
ms214667.pubproperty(en-US,SQL.90).gif DebugMode Gets or sets a Boolean that indicates whether Exec80PackageTask should check if breakpoints are enabled.
ms214667.pubproperty(en-US,SQL.90).gif DTS2000Package Contains the DTS 2000 package. The package is embedded in the task and stored; there is no external file containing the package.
ms214667.pubproperty(en-US,SQL.90).gif ExecutionValue  Returns a user-defined object. This field is read-only. (inherited from Task)
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif PackageName Gets or sets the name of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
ms214667.pubproperty(en-US,SQL.90).gif PackagePassword Gets or sets the package password for the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif 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.
ms214667.pubproperty(en-US,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms214667.pubproperty(en-US,SQL.90).gif WaitForMe  Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task)
ms214667.pubproperty(en-US,SQL.90).gif 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

Public Methods

(see also Protected Methods )

  Name Description
ms214667.pubmethod(en-US,SQL.90).gif AcceptBreakpointManager Passes a BreakpointManager reference to the Exec80PackageTask task. This method is called by the runtime and is not used in code.
ms214667.pubmethod(en-US,SQL.90).gif CanUpdate  (inherited from Task )
ms214667.pubmethod(en-US,SQL.90).gif ClearEmbeddedPackage Removes the stored DTS 2000 package.
ms214667.pubmethod(en-US,SQL.90).gif EmbedPackage Overloaded. Embeds the package inside of the Exec80PackageTask.
ms214667.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms214667.pubmethod(en-US,SQL.90).gif Execute Overridden. Runs the task.
ms214667.pubmethod(en-US,SQL.90).gif GetConnectionID  (inherited from Task )
ms214667.pubmethod(en-US,SQL.90).gif GetConnectionName  (inherited from Task )
ms214667.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms214667.pubmethod(en-US,SQL.90).gif GetPackagePassword Returns the package password.
ms214667.pubmethod(en-US,SQL.90).gif GetSqlPassword Returns the SQL Server password.
ms214667.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms214667.pubmethod(en-US,SQL.90).gif InitializeTask Overridden. Initializes the properties associated with the Exec80PackageTask task. This method is called by the runtime and is not used in code.
ms214667.pubmethod(en-US,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms214667.pubmethod(en-US,SQL.90).gif LoadPackage Loads a package.
ms214667.pubmethod(en-US,SQL.90).gifms214667.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms214667.pubmethod(en-US,SQL.90).gifms214667.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms214667.pubmethod(en-US,SQL.90).gifms214667.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms214667.pubmethod(en-US,SQL.90).gif ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the runtime engine.
ms214667.pubmethod(en-US,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms214667.pubmethod(en-US,SQL.90).gif SuspendExecution Called when the executable needs to suspend. This method is called by the runtime engine.
ms214667.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms214667.pubmethod(en-US,SQL.90).gif Update  (inherited from Task )
ms214667.pubmethod(en-US,SQL.90).gif Validate Overridden. Verifies that the Exec80PackageTask is properly configured.

Top

Protected Methods

  Name Description
ms214667.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms214667.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

Exec80PackageTask Class
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask Namespace