Transfer SQL Server Objects Task

A Transfer SQL Server Objects task lets you transfer one or more Microsoft® SQL Server™ objects between a source and destination server. An object can be:

• Table data.
• A view.
• A referential integrity constraint.
• A stored procedure.
• An index.

The Transfer SQL Server Objects task differs from other tasks in that:

• The task is self-contained; you set source and destination properties on the same task (do not use a Transfer SQL Server Objects task with a Transform Data task).
• Both the source and destination must be SQL Server version 7.0 databases (not a requirement for other DTS tasks).
• The task is SQL-DMO based.

The Transfer SQL Server Objects icon is located in the Task section of the tool palette. Add a Transfer SQL Server Objects task by dragging the icon to the location you want on the DTS Designer workspace.