IfObjectExists Enumeration

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
'Usage
Dim instance As IfObjectExists

public enum IfObjectExists

public enum class IfObjectExists

type 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.

See Also

Reference

Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask Namespace