TransferLoginsTask Members

  • Article

Provides the members and enumerations that allow you to transfer SQL Server logins from one instance of SQL Server to another.

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

Public Constructors

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

Top

Public Properties

  Name Description
ms215264.pubproperty(en-US,SQL.90).gif CopySids Gets or setsa Boolean indicating whether the security identifiers associated with the logins should be copied to the destination.
ms215264.pubproperty(en-US,SQL.90).gif DatabasesList Gets or sets a StringCollection containing the databases on the source server that contain logins to be copied to the destination server.
ms215264.pubproperty(en-US,SQL.90).gif DebugMode Indicates whether a task should check if breakpoints are enabled. This property is set by the run-time engine.
ms215264.pubproperty(en-US,SQL.90).gif DestinationConnection Gets or sets a String containing the name of the SMO connection manager for the destination database.
ms215264.pubproperty(en-US,SQL.90).gif ExecutionValue Overridden. Returns an object containing the number of logins that were transferred.
ms215264.pubproperty(en-US,SQL.90).gif IfObjectExists Gets or sets a value from the IfObjectExists enumeration indicating whether the task should fail, ignore the existing login, or skip the transfer of the login, if a login of the same name exists at the destination.
ms215264.pubproperty(en-US,SQL.90).gif LoginsList Gets or sets a StringCollection containing the names of the logins to transfer.
ms215264.pubproperty(en-US,SQL.90).gif LoginsToTransfer Gets or sets a value from the LoginsToTransfer enumeration indicating which logins to transfer.
ms215264.pubproperty(en-US,SQL.90).gif SourceConnection Gets or sets a String containing the name of the SMO connection manager for the source database.
ms215264.pubproperty(en-US,SQL.90).gif SuspendRequired Gets or sets a Boolean indicating whether a task should suspend when it encounters a breakpoint. This value is set by the run-time engine for the tasks and containers when a breakpoint is encountered
ms215264.pubproperty(en-US,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms215264.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)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms215264.pubmethod(en-US,SQL.90).gif AcceptBreakpointManager Passes a BreakpointManager to a task. This method is called by the runtime and is not used in code.
ms215264.pubmethod(en-US,SQL.90).gif CanUpdate  (inherited from Task )
ms215264.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms215264.pubmethod(en-US,SQL.90).gif Execute Overridden. Runs the task.
ms215264.pubmethod(en-US,SQL.90).gif GetConnectionID  (inherited from Task )
ms215264.pubmethod(en-US,SQL.90).gif GetConnectionName  (inherited from Task )
ms215264.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms215264.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms215264.pubmethod(en-US,SQL.90).gif InitializeTask Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code.
ms215264.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.
ms215264.pubmethod(en-US,SQL.90).gifms215264.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms215264.pubmethod(en-US,SQL.90).gifms215264.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms215264.pubmethod(en-US,SQL.90).gifms215264.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms215264.pubmethod(en-US,SQL.90).gif ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the run-time engine.
ms215264.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.
ms215264.pubmethod(en-US,SQL.90).gif SuspendExecution Indicates that the executable needs to suspend. This method is called by the run-time engine.
ms215264.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms215264.pubmethod(en-US,SQL.90).gif Update  (inherited from Task )
ms215264.pubmethod(en-US,SQL.90).gif Validate Overridden. Verifies that the component is properly configured.

Top

Protected Methods

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

Top

See Also

Reference

TransferLoginsTask Class
Microsoft.SqlServer.Dts.Tasks.TransferLoginsTask Namespace