TransferObjectsTask2 Object
The TransferObjectsTask2 object transfers objects between instances of Microsoft® SQL Server™.
Extended Properties
| DestTranslateChar Property | SourceTranslateChar Property |
| DestUseTransaction Property |
Remarks
The TransferObjectsTask2 object extends the functionality of the existing TransferObjectsTask object and inherits the properties and methods of that object.
The SourceTranslateChar and DestTranslateChar properties turn character translation on or off at the source and destination, respectively. However, the SourceTranslateChar and DestTranslateChar properties are now largely unused as they only support translation of non-Unicode characters.
The transfer of SQL Server objects is done within a transaction on the destination server if the DestUseTransaction property is set.
If the UseCollation property is set, column-level collation settings on the source table are used when transferring data between computers running instances of SQL Server 2000.
For more information about when to use the TransferObjectsTask object instead of the TransferObjectsTask2 object, see Extended DTS Objects.