Hands-On Microsoft SQL Server 2008 Integration Services part 24. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 208 Hands-On Microsoft SQL Server 2008 Integration Services Figure 5-27 Configuration options for the Transfer Logins task Transfer Master Stored Procedures Task The Transfer Master Stored Procedures task copies user-defined stored procedures that are stored in the master database of the source SQL Server instance to the master database of the destination SQL Server instance. Following are the steps you would take to configure this task 1. Specify the name and the description for the task in the General page of the editor window. 2. Specify the source and destination connections using the SMO Connection Manager. Chapter 5 Integration Services Control Flow Tasks 209 3. Choose to copy all or specific stored procedures defined in the master database in the TransferAllStoredProcedures field. You can select the stored procedures from the list in the StoredProceduresList field if you choose to transfer only the specific stored procedures see Figure 5-28 . 4. Finally you can choose to fail the task or overwrite the stored procedures or skip over the stored procedures that already exist at the destination. 5. The Expressions page can be used to modify any property at run time using property expressions. Figure 5-28 Configuration options for Transfer Master Stored Procedures task 210 Hands-On Microsoft SQL Server 2008 Integration Services Transfer SQL Server Objects Task The Transfer SQL Server Objects task transfers SQL Server objects such as Schema Tables Primary Keys and so on along with other types of objects from the source SQL Server instance to the destination SQL Server instance. Following are the steps you perform to configure the options for this task 1. Specify the name and the description for the task in the General page of the editor window. 2. In the Objects page configure source connection and the destination connection using the SMO Connection Manager. Choose the source database and the destination database from the list provided in the database fields of .
