Export (0) Print
Expand All

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.

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)

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

The Exec80PackageTask type exposes the following members.

  NameDescription
Public methodExec80PackageTaskInitializes a new instance of the Exec80PackageTask class.
Top

  NameDescription
Public propertyDebugModeGets or sets a Boolean that indicates whether Exec80PackageTask should check if breakpoints are enabled.
Public propertyDTS2000PackageContains the DTS 2000 package. The package is embedded in the task and stored; there is no external file containing the package.
Public propertyExecutionValueReturns a user-defined object. This field is read-only. (Inherited from Task.)
Public propertyFilenameGets 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 propertyInnerGlobalVariablesGets 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 propertyLocationGets 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 propertyOuterGlobalVariablesGets 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 propertyPackageIDGets 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 propertyPackageNameGets or sets the name of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public propertyPackagePasswordGets or sets the package password for the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.
Public propertyPackageVersionGUIDGets 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 propertySQLPasswordGets 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 propertySQLServerGets 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 propertySQLUsernameGets 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 propertySuspendRequiredGets 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 propertyVersion*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only. (Inherited from Task.)
Public propertyWindowsAuthenticationGets 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

  NameDescription
Public methodAcceptBreakpointManagerPasses a BreakpointManager reference to the Exec80PackageTask task. This method is called by the runtime and is not used in code.
Public methodCanUpdate*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task.)
Public methodClearEmbeddedPackageRemoves the stored DTS 2000 package.
Public methodEmbedPackage(Package)Embeds the package inside of the Exec80PackageTask.
Public methodEmbedPackage(Byte[])Embeds the package inside of the Exec80PackageTask.
Public methodEmbedPackage(String, String, String, Int32, Boolean, String, String, String, String)Embeds the package inside of the Exec80PackageTask.
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodExecuteRuns the task. (Overrides Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Protected methodFinalize (Inherited from Object.)
Public methodGetConnectionIDGets a String containing the ID of the connection. (Inherited from Task.)
Public methodGetConnectionNameGets a String containing the name of the connection. (Inherited from Task.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetPackagePasswordReturns the package password.
Public methodGetSqlPasswordReturns the SQL Server password.
Public methodGetType (Inherited from Object.)
Public methodInitializeTaskInitializes 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 methodLoadFromXMLThis method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Public methodLoadPackageLoads a package.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodResumeExecutionResumes execution of the task after pausing. The task or container is resumed by the runtime engine.
Public methodSaveToXMLThis method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Public methodSuspendExecutionCalled when the executable needs to suspend. This method is called by the runtime engine.
Public methodToString (Inherited from Object.)
Public methodUpdate*** 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 methodValidateVerifies that the Exec80PackageTask is properly configured. (Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)
Top

  NameDescription
Public fieldVariablesGets or sets the Variables object for the Exec80PackageTask task.
Top

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

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

Community Additions

ADD
Show:
© 2014 Microsoft