Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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