Share via

TransferStoredProceduresTask.IfObjectExists Property

  • Article

Gets or sets a value from the IfObjectExists enumeration indicating if the task should fail, overwrite the existing stored procedure, or skip the transfer of the stored procedureif a stored procedurewith the same name exists at the destination.

Namespace:  Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask
Assembly:  Microsoft.SqlServer.TransferStoredProceduresTask (in Microsoft.SqlServer.TransferStoredProceduresTask.dll)

Syntax

'Declaration
Public Property IfObjectExists As IfObjectExists 
    Get 
    Set
'Usage
Dim instance As TransferStoredProceduresTask 
Dim value As IfObjectExists 

value = instance.IfObjectExists

instance.IfObjectExists = value

public IfObjectExists IfObjectExists { get; set; }

public:
virtual property IfObjectExists IfObjectExists {
    IfObjectExists get () sealed;
    void set (IfObjectExists value) sealed;
}

abstract IfObjectExists : IfObjectExists with get, set 
override IfObjectExists : IfObjectExists with get, set

final function get IfObjectExists () : IfObjectExists 
final function set IfObjectExists (value : IfObjectExists)

Property Value

Type: Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask.IfObjectExists
A value from the IfObjectExists enumeration indicating whether the task should fail, ignore the existing stored procedure, or skip the transfer of the stored procedure, if a stored procedureof the same name exists at the destination.

Implements

ITransferStoredProceduresTask.IfObjectExists

See Also

Reference

TransferStoredProceduresTask Class

Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask Namespace