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