Transfer Master Stored Procedures Task Editor (Stored Procedures Page)
Use the Stored Procedures page of the Transfer Master Stored Procedures Task Editor dialog box to specify properties for copying one or more user-defined stored procedures from the master database in one instance of SQL Server instance to a master database in another instance of SQL Server. For more information about this task, see Transfer Master Stored Procedures Task.
Note
This task transfers only user-defined stored procedures owned by dbo from a master database on the source server to a master database on the destination server. Users must be granted the CREATE PROCEDURE permission in the master database on the destination server or be members of the sysadmin fixed server role on the destination server to create stored procedures there.
Options
- SourceConnection
Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the source server.
- DestinationConnection
Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the destination server.
IfObjectExists
Select how the task should handle user-defined stored procedures of the same name that already exist in the master database on the destination server.This property has the options listed in the following table:
Value Description FailTask
Task fails if stored procedures of the same name already exist in the master database on the destination server.
Overwrite
Task overwrites stored procedures of the same name in the master database on the destination server.
Skip
Task skips stored procedures of the same name that exist in the master database on the destination server.
TransferAllStoredProcedures
Select whether all user-defined stored procedures in the master database on the source server should be copied to the destination server.Value Description True
Copy all user-defined stored procedures in the master database.
False
Copy only the specified stored procedures.
- StoredProceduresList
Select which user-defined stored procedures in the master database on the source server should be copied to the destination master database. This option is only available when TransferAllStoredProcedures is set to False.
See Also
Reference
Task Properties UI Reference
Transfer Master Stored Procedures Task Editor (General Page)
Expressions Page
Other Resources
Integration Services Error and Message Reference
Integration Services Tasks
SMO Connection Manager