DTSLib, COM interface constants for VB.Net / VBScript
DTSLib - interface constants
This page contains simple VBA include for the DTSLib COM library.
library parameters| File Name | Program Files\Microsoft SQL Server\100\DTS\Binn\DTS.dll |
|---|
| Guid | {FAD11436-A84C-4720-8D20-B07FE84FDE74} |
|---|
| Enums | 28 |
|---|
DTSFileConnectionUsageTypeenum, 4 members.Public Enum DTSFileConnectionUsageType
DTSFCU_FILEEXISTS = 0
DTSFCU_CREATEFILE = 1
DTSFCU_FOLDEREXISTS = 2
DTSFCU_CREATEFOLDER = 3
End Enum
DTSSignatureStatusenum, 4 members.Public Enum DTSSignatureStatus
DTSSS_INVALID = 0
DTSSS_NOTPRESENT = 1
DTSSS_GOOD = 2
DTSSS_UNTRUSTED = 3
End Enum
DTSPipelineComponentTypeenum, 4 members.Public Enum DTSPipelineComponentType
DTSPCT_TRANSFORM = 0
DTSPCT_SOURCEADAPTER = 1
DTSPCT_DESTINATIONADAPTER = 2
DTSPCT_VIEW = 3
End Enum
DTSExecResultenum, 4 members.Public Enum DTSExecResult
DTSER_FAILURE = 1
DTSER_SUCCESS = 0
DTSER_COMPLETION = 2
DTSER_CANCELED = 3
End Enum
DTSForcedExecResultenum, 4 members.Public Enum DTSForcedExecResult
DTSFER_FAILURE = 1
DTSFER_SUCCESS = 0
DTSFER_COMPLETION = 2
DTSFER_NONE = -1
End Enum
DTSCheckpointUsageenum, 3 members.Public Enum DTSCheckpointUsage
DTSCU_NEVER = 0
DTSCU_IFEXISTS = 1
DTSCU_ALWAYS = 2
End Enum
DTSTransactionOptionenum, 3 members.Public Enum DTSTransactionOption
DTSTO_NotSupported = 0
DTSTO_Supported = 1
DTSTO_Required = 2
End Enum
DTSExecStatusenum, 6 members.Public Enum DTSExecStatus
DTSES_NONE = 1
DTSES_VALIDATING = 2
DTSES_EXECUTING = 3
DTSES_SUSPENDED = 4
DTSES_COMPLETED = 5
DTSES_ABEND = 6
End Enum
DTSPackageTypeenum, 6 members.Public Enum DTSPackageType
DTSPKT_DEFAULT = 0
DTSPKT_DTSWIZARD = 1
DTSPKT_DTSDESIGNER = 2
DTSPKT_SQLREPL = 3
DTSPKT_DTSDESIGNER100 = 5
DTSPKT_SQLDBMAINT = 6
End Enum
DTSLoggingModeenum, 3 members.Public Enum DTSLoggingMode
DTSLM_USEPARENTSETTING = 0
DTSLM_ENABLED = 1
DTSLM_DISABLED = 2
End Enum
DTSEventFilterKindenum, 2 members.Public Enum DTSEventFilterKind
DTSEFK_INCLUSION = 0
DTSEFK_EXCLUSION = 1
End Enum
DTSProviderTypeenum, 5 members.Public Enum DTSProviderType
DTSPT_OLEDB = -1
DTSPT_ODBC = -2
DTSPT_DTS_SOURCE = -3
DTSPT_DTS_DEST = -4
DTSPT_UNKNOWN = 0
End Enum
DTSProviderSubTypeenum, 9 members.Public Enum DTSProviderSubType
DTSPST_ACCESS = -1
DTSPST_EXCEL = -2
DTSPST_PARADOX = -3
DTSPST_SQLSERVER = -4
DTSPST_DBASE = -5
DTSPST_FLATFILE = -6
DTSPST_ORACLE = -7
DTSPST_DB2 = -8
DTSPST_NONE = 0
End Enum
DTSConfigurationTypeenum, 11 members.Public Enum DTSConfigurationType
DTSCT_PARENTVARIABLE = 0
DTSCT_CONFIGFILE = 1
DTSCT_ENVVARIABLE = 2
DTSCT_REGENTRY = 3
DTSCT_IPARENTVARIABLE = 4
DTSCT_ICONFIGFILE = 5
DTSCT_IREGENTRY = 6
DTSCT_SQLSERVER = 7
DTSCT_INIFILE = 8
DTSCT_ISQLSERVER = 9
DTSCT_IINIFILE = 10
End Enum
DTSBreakpointHitTestenum, 5 members.Public Enum DTSBreakpointHitTest
DTSBHT_ALWAYS = 0
DTSBHT_GREATER_OR_EQUAL = 1
DTSBHT_EQUAL = 2
DTSBHT_MULTIPLE = 3
DTSBHT_EXPRESSION = 4
End Enum
DTSExecutionLocationenum, 3 members.Public Enum DTSExecutionLocation
DTSEL_INPROC_SERVER = 0
DTSEL_LOCAL_SERVER = 1
DTSEL_REMOTE_SERVER = 2
End Enum
DTSPrecedenceEvalOpenum, 4 members.Public Enum DTSPrecedenceEvalOp
DTSPEO_EXPRESSION = 1
DTSPEO_CONSTRAINT = 2
DTSPEO_EXPRESSIONANDCONSTRAINT = 3
DTSPEO_EXPRESSIONORCONSTRAINT = 4
End Enum
DTSPriorityClassenum, 5 members.Public Enum DTSPriorityClass
DTSPC_DEFAULT = 0
DTSPC_ABOVE_NORMAL = 1
DTSPC_NORMAL = 2
DTSPC_BELOW_NORMAL = 3
DTSPC_IDLE = 4
End Enum
DTSProtectionLevelenum, 6 members.Public Enum DTSProtectionLevel
DTSPL_DONTSAVESENSITIVE = 0
DTSPL_ENCRYPTSENSITIVE_USERKEY = 1
DTSPL_ENCRYPTSENSITIVE_PASSWORD = 2
DTSPL_ENCRYPTALL_PASSWORD = 3
DTSPL_ENCRYPTALL_USERKEY = 4
DTSPL_SERVERSTORAGE = 5
End Enum
DTSPackageInformationFlagsenum, 2 members.Public Enum DTSPackageInformationFlags
DTSPIF_FOLDER = 0
DTSPIF_PACKAGE = 1
End Enum
DTSObjectHostTypeenum, 4 members.Public Enum DTSObjectHostType
DTSOHT_TASK = 0
DTSOHT_CONNECTIONMANAGER = 1
DTSOHT_LOGPROVIDER = 2
DTSOHT_FOREACHENUMERATOR = 3
End Enum
DTSLogEntryFrequencyenum, 3 members.Public Enum DTSLogEntryFrequency
DTSLEF_OCCASIONAL = 0
DTSLEF_CONSISTENT = 1
DTSLEF_PROPORTIONAL = 2
End Enum
DTSPropertyKindenum, 5 members.Public Enum DTSPropertyKind
DTSPK_OTHER = 0
DTSPK_VARIABLE_READONLY = 1
DTSPK_VARIABLE_READWRITE = 2
DTSPK_CONNECTION = 3
DTSPK_SENSITIVE = 4
End Enum
DTSObjectReferenceTypeenum, 3 members.Public Enum DTSObjectReferenceType
DTSORT_VARIABLE_READONLY = 0
DTSORT_VARIABLE_READWRITE = 1
DTSORT_CONNECTION = 2
End Enum
DTSExcelVersionenum, 5 members.Public Enum DTSExcelVersion
DTSExcelVer_3 = 0
DTSExcelVer_4 = 1
DTSExcelVer_5 = 2
DTSExcelVer_8 = 3
DTSExcelVer_2007 = 4
End Enum
DTSProductLevelenum, 5 members.Public Enum DTSProductLevel
DTSPL_NONE = 0
DTSPL_EXPRESS = 5
DTSPL_WORKGROUP = 10
DTSPL_STANDARD = 20
DTSPL_ENTERPRISE = 30
End Enum
DataTypeenum, 54 members.Public Enum DataType
DT_EMPTY = 0
DT_NULL = 1
DT_I2 = 2
DT_I4 = 3
DT_R4 = 4
DT_R8 = 5
DT_CY = 6
DT_DATE = 7
DT_BOOL = 11
DT_DECIMAL = 14
DT_I1 = 16
DT_UI1 = 17
DT_UI2 = 18
DT_UI4 = 19
DT_I8 = 20
DT_UI8 = 21
DT_FILETIME = 64
DT_GUID = 72
DT_BYTES = 128
DT_STR = 129
DT_WSTR = 130
DT_NUMERIC = 131
DT_DBDATE = 133
DT_DBTIME = 134
DT_DBTIMESTAMP = 135
DT_DBTIME2 = 145
DT_DBTIMESTAMPOFFSET = 146
DT_IMAGE = 301
DT_TEXT = 302
DT_NTEXT = 303
DT_DBTIMESTAMP2 = 304
DT_BYREF_I2 = 16386
DT_BYREF_I4 = 16387
DT_BYREF_R4 = 16388
DT_BYREF_R8 = 16389
DT_BYREF_CY = 16390
DT_BYREF_DATE = 16391
DT_BYREF_BOOL = 16395
DT_BYREF_DECIMAL = 16398
DT_BYREF_I1 = 16400
DT_BYREF_UI1 = 16401
DT_BYREF_UI2 = 16402
DT_BYREF_UI4 = 16403
DT_BYREF_I8 = 16404
DT_BYREF_UI8 = 16405
DT_BYREF_FILETIME = 16448
DT_BYREF_GUID = 16456
DT_BYREF_NUMERIC = 16515
DT_BYREF_DBDATE = 16517
DT_BYREF_DBTIME = 16518
DT_BYREF_DBTIMESTAMP = 16519
DT_BYREF_DBTIME2 = 16520
DT_BYREF_DBTIMESTAMPOFFSET = 16521
DT_BYREF_DBTIMESTAMP2 = 16522
End Enum
DTS_MANAGED_INFO_TYPEenum, 5 members.Public Enum DTS_MANAGED_INFO_TYPE
TypeTask = 0
TypeComponent = 1
TypeForEachEnumerator = 2
TypeLogProvider = 3
TypeConnection = 4
End Enum
|