IfObjectExists Enumeration

  • Article

Contains values used by the IfObjectExists property of the TransferStoredProceduresTask to determine how to handle a transfer when the stored procedure exists at the destination.

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

Syntax

'Declaration
Public Enumeration IfObjectExists

public enum IfObjectExists

public enum class IfObjectExists

public enum IfObjectExists

public enum IfObjectExists

Members

Member name Description
FailTask Causes the task to fail if the same stored procedure exists at the destination.
Overwrite Overwrites the job if the same stored procedure exists at the destination.
Skip Skips the transfer of a stored procedure if the same stored procedure exists at the destination.

Platforms

Development Platforms

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

Target Platforms

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

See Also

Reference

Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask Namespace