Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS

6.       In the Transfer Error Messages Task Editor, you need to configure a Source Connection and a Destination Connection. In this example, the source server is a SQL Server 2005 instance and the destination server is a SQL Server 2008 instance. There are three different options available under the IfObjectExists drop down box namely

a.       FailTask

b.      Overwrite

c.       Skip

In this example, you need to choose Overwrite as the selection for the IfObjectExists option, and also choose False as the value for TransferAllErrorMessages. Next click on Collection option for ErrorMessagesList to Select Error Messages as shown in the snippet below.

Once you have selected the respective Error Message click OK to close the Select Error Messages window and click OK once again to close the Transfer Error Messages Task Editor window and save all the configuration changes.

7.       Drag and drop the “Transfer Master Stored Procedures Task” from the toolbox to the Sequence Container in the Control Flow window and rename it “Transfer sp_KillDatabaseUsers Stored Procedures”.

8.       Double click the Transfer Master Stored Procedures Task to open up the Transfer Master Stored Procedure Task Editor as shown in the snippet below.

9.       In the Transfer Master Stored Procedures Task Editor, you will need to configure a Source Connection and a Destination Connection. In this example, the source server is a SQL Server 2005 instance and the destination server is a SQL Server 2008 instance. There are three different options available under the IfObjectExists drop down box namely

a.       FailTask

b.      Overwrite

c.       Skip

Choose Overwrite for the IfObjectExists option and also choose False as the value for TransferAllStoredProcedures option. Next what you need to do is to click   the Collection option for StoredProceduresList to select the Stored Procedures as shown in the snippet below.

Once you have selected the Stored Procedures click OK to close the Select Stored Procedures window and click OK once again to close Transfer Master Stored Procedures Task Editor Window and save all the configuration changes.

Continues…

Pages: 1 2 3




Related Articles :

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |