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)

public enum class IfObjectExists

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

Return to top
Show: