Transfer Error Messages Task
The Transfer Error Messages task copies one or more SQL Server user-defined error messages from one SQL Server to another. Once you define error messages on one SQL Server for your application, you might like to make those error messages available at all the servers wherever you install your application. This task helps avoid the rework in creating these error messages. You create the error messages on the first server by using the sp_addmessage stored procedure and use this task to copy the defined error messages to the remaining servers. These messages can be viewed using the sys.messages catalog view.
You can configure the task as follows:
This task editor has three pages. Specify name and description for this ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
