DTSTransfer_ScriptOptionEx constants specify extended scripting options. They are equivalent to SQLDMO_SCRIPT2_TYPE constants used by SQL-DMO.
| Constant | Value | Description |
|---|---|---|
| DTSTransfer_ScriptEx_AgentAlertJob | 2048 | Include job in alert scripting. |
| DTSTransfer_ScriptEx_AgentNotify | 1024 | Script notification for SQLServerAgent alert object. |
| DTSTransfer_ScriptEx_AnsiFile | 2 | Generate ANSI output file. |
| DTSTransfer_ScriptEx_AnsiPadding | 1 | Explicitly SET ANSI PADDING on or off before the CREATE TABLE statement. |
| DTSTransfer_ScriptEx_EncryptPWD | 128 | Script encrypted password for logins. |
| DTSTransfer_ScriptEx_FullTextIndex | 4096 | Include full-text index scripting (table only). |
| DTSTransfer_ScriptEx_MarkTriggers | 32 | Mark system triggers. For replication, single table script only. |
| DTSTransfer_ScriptEx_NoFG | 16 | Do not generate ON <filegroup>. For replication. |
| DTSTransfer_ScriptEx_NonStop | 8 | When error occurs during script file generation, log error and continue. |
| DTSTransfer_ScriptEx_NoWhatIfIndexes | 512 | Do not script What-If indexes (default: script out). |
| DTSTransfer_ScriptEx_OnlyUserTriggers | 64 | Only script user triggers. For replication, single table script only. |
| DTSTransfer_ScriptEx_SeparateXPs | 256 | Script XP to a separate file (Convert). |
| DTSTransfer_ScriptEx_TransferDefault | 4096 | Default. |
| DTSTransfer_ScriptEx_UnicodeFile | 4 | Generate UNICODE output file. |