DTSPipeline, COM interface constants for VB.Net / VBScript

DTSPipeline - interface constants

     This page contains simple VBA include for the DTSPipeline COM library.

library parameters

File NameProgram Files\Microsoft SQL Server\100\DTS\Binn\DTSPipeline.dll
Guid{6E944EA2-14A0-4997-98FA-3E1995D80BD9}
Enums12

DTSPIPELINEVERSION

enum, 1 members.
Public Enum DTSPIPELINEVERSION
  DTSPIPELINE_CURRENTVERSION = 0  '&H0
End Enum

DTPSTATUSENUM

enum, 14 members.
Public Enum DTPSTATUSENUM
  DTPSTATUS_OK = 0  '&H0
  DTPSTATUS_BADACCESSOR = 1  '&H1
  DTPSTATUS_CANTCONVERTVALUE = 2  '&H2
  DTPSTATUS_ISNULL = 3  '&H3
  DTPSTATUS_TRUNCATED = 4  '&H4
  DTPSTATUS_SIGNMISMATCH = 5  '&H5
  DTPSTATUS_DATAOVERFLOW = 6  '&H6
  DTPSTATUS_CANTCREATE = 7  '&H7
  DTPSTATUS_UNAVAILABLE = 8  '&H8
  DTPSTATUS_PERMISSIONDENIED = 9  '&H9
  DTPSTATUS_INTEGRITYVIOLATION = 10  '&HA
  DTPSTATUS_SCHEMAVIOLATION = 11  '&HB
  DTPSTATUS_BADSTATUS = 12  '&HC
  DTPSTATUS_DEFAULT = 13  '&HD
End Enum

DTSValidationStatus

enum, 4 members.
Public Enum DTSValidationStatus
  VS_ISVALID = 0  '&H0
  VS_ISBROKEN = 1  '&H1
  VS_NEEDSNEWMETADATA = 2  '&H2
  VS_ISCORRUPT = 3  '&H3
End Enum

DTSInsertPlacement

enum, 2 members.
Public Enum DTSInsertPlacement
  IP_BEFORE = 0  '&H0
  IP_AFTER = 1  '&H1
End Enum

DTSObjectType

enum, 16 members.
Public Enum DTSObjectType
  OT_UNSPECIFIED = 0  '&H0
  OT_SOURCEADAPTER = 1  '&H1
  OT_DESTINATIONADAPTER = 2  '&H2
  OT_TRANSFORM = 4  '&H4
  OT_COMPONENT = 8  '&H8
  OT_COMPONENTVIEWER = 16  '&H10
  OT_PATH = 32  '&H20
  OT_INPUT = 64  '&H40
  OT_VIRTUALINPUT = 128  '&H80
  OT_OUTPUT = 256  '&H100
  OT_INPUTCOLUMN = 512  '&H200
  OT_OUTPUTCOLUMN = 1024  '&H400
  OT_VIRTUALINPUTCOLUMN = 2048  '&H800
  OT_PROPERTY = 4096  '&H1000
  OT_RUNTIMECONNECTION = 8192  '&H2000
  OT_EXTERNALMETADATACOLUMN = 16384  '&H4000
End Enum

DTSPersistenceFormat

enum, 2 members.
Public Enum DTSPersistenceFormat
  PF_XML = 1  '&H1
  PF_SQLSERVER = 2  '&H2
End Enum

DTSBufferHandlePresetValues

enum, 1 members.
Public Enum DTSBufferHandlePresetValues
  H_ALL = -1  '&HFFFFFFFF
End Enum

DTSBufferFlags

enum, 2 members.
Public Enum DTSBufferFlags
  BUFF_NOOLEDB = 1  '&H1
  BUFF_INIT = 2  '&H2
End Enum

DTSUsageType

enum, 3 members.
Public Enum DTSUsageType
  UT_READONLY = 0  '&H0
  UT_READWRITE = 1  '&H1
  UT_IGNORED = 2  '&H2
End Enum

DTSPersistState

enum, 3 members.
Public Enum DTSPersistState
  PS_DEFAULT = 0  '&H0
  PS_PERSISTASHEX = 1  '&H1
  PS_PERSISTASCDATA = 2  '&H2
End Enum

DTSRowDisposition

enum, 4 members.
Public Enum DTSRowDisposition
  RD_NotUsed = 0  '&H0
  RD_IgnoreFailure = 1  '&H1
  RD_RedirectRow = 2  '&H2
  RD_FailComponent = 4  '&H4
End Enum

DTSCustomPropertyExpressionType

enum, 2 members.
Public Enum DTSCustomPropertyExpressionType
  CPET_NONE = 0  '&H0
  CPET_NOTIFY = 1  '&H1
End Enum
WUtils.com