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




Array

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 |