DatabaseMaintenanceBaseTask Members

Article
04/28/2008

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

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

Public Constructors

	Name	Description
	DatabaseMaintenanceBaseTask	Initializes a new instance of the ExecuteSQLTask class.

Top

Public Properties

(see also Protected Properties )

	Name	Description
	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
	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
	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
	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)
	Version	* Member deprecated; see Remarks. * Returns the version of the task. This property is read-only. (inherited from Task)

Top

Protected Properties

	Name	Description
	SqlBatchCommands

Top

Public Methods

(see also Protected Methods )

	Name	Description
	CanDowngradeTo
	CanUpdate	(inherited from Task )
	CopyTo
	DowngradeTo
	Equals	Overloaded. (inherited from DtsObject )
	Execute	Overridden.
	GetConnectionID	(inherited from Task )
	GetConnectionName	(inherited from Task )
	GetHashCode	Returns the hash code for this instance. (inherited from DtsObject)
	GetType	(inherited from Object )
	InitializeTask	Overridden.
	LoadFromXML
	OnAddedToTaskHost
	op_Equality	(inherited from DtsObject )
	op_Inequality	(inherited from DtsObject )
	ReferenceEquals	(inherited from Object )
	SaveToXML
	ToString	(inherited from Object )
	Update	(inherited from Task )
	Validate	Overridden.