Share via


DatabaseMaintenanceBaseTask Class

Definition

public ref class DatabaseMaintenanceBaseTask : Microsoft::SqlServer::Dts::Tasks::ExecuteSQLTask::ExecuteSQLTask, Microsoft::SqlServer::Dts::Runtime::IDTSComponentPersist, Microsoft::SqlServer::Dts::Runtime::IDTSDowngradableObject, Microsoft::SqlServer::Management::DatabaseMaintenance::IDatabaseMaintenanceBaseTaskInterface
public class DatabaseMaintenanceBaseTask : Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Dts.Runtime.IDTSDowngradableObject, Microsoft.SqlServer.Management.DatabaseMaintenance.IDatabaseMaintenanceBaseTaskInterface
type DatabaseMaintenanceBaseTask = class
    inherit ExecuteSQLTask
    interface IDatabaseMaintenanceBaseTaskInterface
    interface IDTSComponentPersist
    interface IDTSDowngradableObject
Public Class DatabaseMaintenanceBaseTask
Inherits ExecuteSQLTask
Implements IDatabaseMaintenanceBaseTaskInterface, IDTSComponentPersist, IDTSDowngradableObject
Inheritance
DatabaseMaintenanceBaseTask
Derived
Implements

Constructors

DatabaseMaintenanceBaseTask()

Properties

BypassPrepare

Gets or sets a Boolean that indicates whether the Execute SQL task skips preparation of the statement when sending the SQL statement to the relational database management system (RDBMS).

(Inherited from ExecuteSQLTask)
CodePage

Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes. Translation occurs either when storing values to or extracting values from databases.

(Inherited from ExecuteSQLTask)
Connection

Gets or sets the name of the connection manager that connects to the relational database management system (RDBMS) where the Execute SQL task is run.

(Inherited from ExecuteSQLTask)
DatabaseSelectionType
ExecutionValue

Returns the number of rows affected by the SQL statement or statements.

(Inherited from ExecuteSQLTask)
ExtendedLogging
IgnoreDatabasesInNotOnlineState
IsStoredProcedure

Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.

(Inherited from ExecuteSQLTask)
LocalConnectionForLogging
ObjectTypeSelection
ParameterBindings

Returns an object that implements IDTSParameterBindings.

(Inherited from ExecuteSQLTask)
ResultSetBindings

Returns an object that implements IDTSParameterBindings.

(Inherited from ExecuteSQLTask)
ResultSetType

Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.

(Inherited from ExecuteSQLTask)
RunId
SelectedDatabases
SelectedTables
ServerVersion
SqlBatchCommands
SqlStatementSource

Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.

(Inherited from ExecuteSQLTask)
SqlStatementSourceType

Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.

(Inherited from ExecuteSQLTask)
TableSelectionType
TargetServerVersion (Inherited from Task)
TaskConnectionName
TaskName
TaskNameWasModified
TimeOut

Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.

(Inherited from ExecuteSQLTask)
TypeConversionMode

Gets or sets the conversion mode used by the Execute SQL Task.

(Inherited from ExecuteSQLTask)
Version

*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only.

(Inherited from Task)

Methods

CanDowngradeTo(Int32)
CanUpdate(String)

*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML.

(Inherited from Task)
CopyTo(DatabaseMaintenanceBaseTask)
DowngradeTo(Int32, XmlElement)
Equals(Object)

Determines whether two object instances are equal.

(Inherited from DtsObject)
Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)
GetConnectionID(Connections, String)

Gets a String containing the ID of the connection.

(Inherited from Task)
GetConnectionName(Connections, String)

Gets a String containing the name of the connection.

(Inherited from Task)
GetHashCode()

Returns the hash code for this instance.

(Inherited from DtsObject)
InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)
LoadFromXML(XmlElement, IDTSInfoEvents)
OnAddedToTaskHost(TaskHost)
SaveToXML(XmlDocument, IDTSInfoEvents)
Update(String)

*** Member deprecated; see Remarks. ***   This method updates the old package XML with the new package XML if CanUpdate(String) is set to true.

(Inherited from Task)
Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)
WriteToDTSLog(IDTSLogging, String)

Applies to