DTS Programming
DTSTransfer_ScriptOption
The DTSSQLServerStorageFlags constants specify extended scripting options. They are equivalent to SQLDMO_SCRIPT2_TYPE constants used by SQL-DMO.
The DTSTransfer_ScriptOption constants specify scripting options for the TransferObjectsTask ScriptOption property.
| Constant | Value | Description |
|---|---|---|
| DTSTransfer_Script_Aliases | 16384 | For users, script aliases. |
| DTSTransfer_Script_AppendToFile | 256 | Append to output file if it already exists. |
| DTSTransfer_Script_Bindings | 128 | Include rule/default bindings (table only). |
| DTSTransfer_Script_ClusteredIndexes | 8 | Include clustered index creation (table only). |
| DTSTransfer_Script_DatabasePermissions | 32 | Database (statement) permissions. |
| DTSTransfer_Script_Default | 4 | Object creation only. |
| DTSTransfer_Script_DRI_All | 532676608 | All the foregoing (specifying this and not PrimaryObject gets just DRI output). |
| DTSTransfer_Script_DRI_AllConstraints | 520093696 | Bitmask of all constraint types (primary key, foreign key, unique, check, default). |
| DTSTransfer_Script_DRI_AllKeys | 469762048 | Bitmask of all key types (primary key, foreign key, unique). |
| DTSTransfer_Script_DRI_Checks | 16777216 | Generated script creates column-specified CHECK constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a Microsoft SQL Server™ table. |
| DTSTransfer_Script_DRI_Clustered | 8388608 | Generated script creates clustered indexes. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| DTSTransfer_Script_DRI_Defaults | 33554432 | Generated script includes column-specified defaults. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| DTSTransfer_Script_DRI_ForeignKeys | 134217728 | Generated script creates FOREIGN KEY constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| DTSTransfer_Script_DRI_NonClustered | 4194304 | Generated script creates nonclustered indexes. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| DTSTransfer_Script_DRI_PrimaryKey | 268435456 | Generated script creates PRIMARY KEY constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| DTSTransfer_Script_DRI_UniqueKeys | 67108864 | Generated script creates candidate keys defined using a unique index. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| DTSTransfer_Script_DRIIndexes | 65536 | Script DRI-generated indexes as indexes if NoDRI is specified. |
| DTSTransfer_Script_DRIWithNoCheck | 536870912 | Script DRI with nocheck (not included in _DRI_All). |
| DTSTransfer_Script_Drops | 1 | Include object drops. |
| DTSTransfer_Script_IncludeHeaders | 131072 | Include descriptive header in individual object script output. |
| DTSTransfer_Script_IncludeIfNotExists | 4096 | Include "if not exists" on object creation. |
| DTSTransfer_Script_Indexes | 73736 | Include all index creation (table only). |
| DTSTransfer_Script_NoCommandTerm | 32768 | Do not append "GO" to commands. |
| DTSTransfer_Script_NoDRI | 512 | Do not include DRI (use only if you are targeting a Microsoft SQL Server version 6.0 or earlier installation with scripts). |
| DTSTransfer_Script_NoIdentity | 1073741824 | Script with no IDENTITY attribute (such as for replication). |
| DTSTransfer_Script_NonClusteredIndexes | 8192 | Includes nonclustered index creation (table only). |
| DTSTransfer_Script_ObjectPermissions | 2 | Includes object creation. |
| DTSTransfer_Script_OwnerQualify | 262144 | Owner-qualify DROP statements (and CREATE where possible). |
| DTSTransfer_Script_Permissions | 34 | Both database and object permissions (for scripting users). |
| DTSTransfer_Script_PrimaryObject | 4 | Generate Transact-SQL creating the referenced component. |
| DTSTransfer_Script_SortedData | 1048576 | If the index or constraint was clustered, append sorted_data. |
| DTSTransfer_Script_SortedDataReorg | 2097152 | Same as DTSTransfer_Script_SortedData, but DTSTransfer_Script_Sorted Data Reorg is used to preserve fillfactor. |
| DTSTransfer_Script_TimestampToBinary | 524288 | Converts timestamp columns to binary(8) (for replication, and so on). |
| DTSTransfer_Script_ToFileOnly | 64 | If not set, a string is returned (if file is nonnull, both are done). |
| DTSTransfer_Script_TransferDefault | 2147061505 | The default script type for a transfer. This is combination of following flags DTSTransfer_Script_PrimaryObject DTSTransfer_Script_Bindings DTSTransfer_Script_ClusteredIndexes DTSTransfer_Script_NonClusteredIndexes DTSTransfer_Script_Triggers DTSTransfer_Script_ToFileOnly DTSTransfer_Script_Permissions DTSTransfer_Script_IncludeHeaders DTSTransfer_Script_Aliases DTSTransfer_Script_IncludeIfNotExists DTSTransfer_Script_OwnerQualify DRI-restrictive flags. These may be combined with PrimaryObject as desired. These are used to include or exclude specific DRI components. |
| DTSTransfer_Script_Triggers | 16 | Include trigger creation (table only). |
| DTSTransfer_Script_UDDTsToBaseType | 1024 | Converts user-defined data types to base type when creating columns (table only). |
| DTSTransfer_Script_UseQuotedIdentifiers | 2147483648 | Scripts with quoted identifiers. Also will cause the Transfer object to SET QUOTED_IDENTIFIER ON on the destination. |