DTSSQLObjectType constants specify object copying options for the TransferObjectsTask AddObjectForTransfer and GetObjectForTransfer methods.
| Constant | Value | Description |
|---|---|---|
| DTSSQLObj_AllDatabaseObjects | 511 | System and database objects |
| DTSSQLObj_AllDatabaseUserObjects | 509 | User database objects |
| DTSSQLObj_Default | 64 | Defaults |
| DTSSQLObj_Rule | 128 | Rules |
| DTSSQLObj_StoredProcedure | 16 | Stored procedures |
| DTSSQLObj_SystemTable | 2 | System tables |
| DTSSQLObj_Trigger | 256 | Triggers |
| DTSSQLObj_UserDefinedDatatype | 1 | User-defined data types |
| DTSSQLObj_UserTable | 8 | User tables |
| DTSSQLObj_View | 4 | Views |