Transfer Error Messages Task Editor (Messages Page)
Use the Messages page of the Transfer Error Messages Task Editor dialog box to specify properties for copying one or more SQL Server user-defined error messages from one instance of SQL Server to another. For more information about this task, see Transfer Error Messages Task.
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 whether the task should overwrite existing user-defined error messages, skip existing messages, or fail if error messages of the same name already exist on the destination server.
TransferAllErrorMessages
Select whether the task should copy all or only the specified user-defined messages from the source server to the destination server.This property has the options listed in the following table:
Value Description True
Copy all user-defined messages.
False
Copy only the specified user-defined messages.
ErrorMessagesList
Click the browse button (…) to select the error messages to copy.Note
You must specify the SourceConnection before you can select error messages to copy.
ErrorMessageLanguagesList
Click the browse button (…) to select the languages for which to copy user-defined error messages to the destination server. A us_english (code page 1033) version of the message must exist on the destination server before you can transfer other language versions of the message to that server.Note
You must specify the SourceConnection before you can select error messages to copy.
See Also
Reference
Task Properties UI Reference
Transfer Error Messages Task Editor (General Page)
Transfer Error Messages Task Editor (General Page)
Other Resources
Integration Services Error and Message Reference
Integration Services Tasks
SMO Connection Manager
SMO Connection Manager