Export (0) Print
Expand All

DTSTransfer_ScriptOption

SQL Server 2000

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.

See Also

ScriptOption Property

Show:
© 2015 Microsoft