TransferStoredProceduresTask.IfObjectExists Property

Article
12/03/2008

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

public IfObjectExists IfObjectExists { get; set; }

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

/** @property */
public final IfObjectExists get_IfObjectExists ()

/** @property */
public final void set_IfObjectExists (IfObjectExists value)

public final function get IfObjectExists () : IfObjectExists

public final function set IfObjectExists (value : IfObjectExists)

Property Value

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.

Thread Safety

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

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms