dts_tlb.pas

delphi使用sqlserver2000中dts导入导出数据

  DTSTransfer_Script_NonClusteredIndexes = $00002000;
  DTSTransfer_Script_Indexes = $00012008;
  DTSTransfer_Script_Aliases = $00004000;
  DTSTransfer_Script_NoCommandTerm = $00008000;
  DTSTransfer_Script_DRIIndexes = $00010000;
  DTSTransfer_Script_IncludeHeaders = $00020000;
  DTSTransfer_Script_OwnerQualify = $00040000;
  DTSTransfer_Script_TimestampToBinary = $00080000;
  DTSTransfer_Script_SortedData = $00100000;
  DTSTransfer_Script_SortedDataReorg = $00200000;
  DTSTransfer_Script_TransferDefault = $800670FF;
  DTSTransfer_Script_DRI_NonClustered = $00400000;
  DTSTransfer_Script_DRI_Clustered = $00800000;
  DTSTransfer_Script_DRI_Checks = $01000000;
  DTSTransfer_Script_DRI_Defaults = $02000000;
  DTSTransfer_Script_DRI_UniqueKeys = $04000000;
  DTSTransfer_Script_DRI_ForeignKeys = $08000000;
  DTSTransfer_Script_DRI_PrimaryKey = $10000000;
  DTSTransfer_Script_DRI_AllKeys = $1C000000;
  DTSTransfer_Script_DRI_AllConstraints = $1F000000;
  DTSTransfer_Script_DRI_All = $1FC00000;
  DTSTransfer_Script_DRIWithNoCheck = $20000000;
  DTSTransfer_Script_NoIdentity = $40000000;
  DTSTransfer_Script_UseQuotedIdentifiers = $80000000;

// Constants for enum DTSTransfer_ScriptOptionEx
type
  DTSTransfer_ScriptOptionEx = TOleEnum;
const
  DTSTransfer_ScriptEx_TransferDefault = $00001010;
  DTSTransfer_ScriptEx_AnsiPadding = $00000001;
  DTSTransfer_ScriptEx_AnsiFile = $00000002;
  DTSTransfer_ScriptEx_UnicodeFile = $00000004;
  DTSTransfer_ScriptEx_NonStop = $00000008;
  DTSTransfer_ScriptEx_NoFG = $00000010;
  DTSTransfer_ScriptEx_MarkTriggers = $00000020;
  DTSTransfer_ScriptEx_OnlyUserTriggers = $00000040;
  DTSTransfer_ScriptEx_EncryptPWD = $00000080;
  DTSTransfer_ScriptEx_SeparateXPs = $00000100;
  DTSTransfer_ScriptEx_NoWhatIfIndexes = $00000200;
  DTSTransfer_ScriptEx_AgentNotify = $00000400;
  DTSTransfer_ScriptEx_AgentAlertJob = $00000800;
  DTSTransfer_ScriptEx_FullTextIndex = $00080000;
  DTSTransfer_ScriptEx_LoginSID = $00100000;
  DTSTransfer_ScriptEx_FullTextCat = $00200000;
  DTSTransfer_ScriptEx_ExtendedProperty = $00400000;
  DTSTransfer_ScriptEx_NoCollation = $00800000;
  DTSTransfer_ScriptEx_70Only = $01000000;
  DTSTransfer_ScriptEx_JobDisable = $02000000;

// Constants for enum DTSBulkInsert_DataFileType
type
  DTSBulkInsert_DataFileType = TOleEnum;
const
  DTSBulkInsert_DataFileType_Char = $00000000;
  DTSBulkInsert_DataFileType_Native = $00000001;
  DTSBulkInsert_DataFileType_WideChar = $00000002;
  DTSBulkInsert_DataFileType_WideNative = $00000003;

// Constants for enum DTSLineageOptions
type
  DTSLineageOptions = TOleEnum;
const
  DTSLineage_None = $00000000;
  DTSLineage_AddLineageVariables = $00000001;
  DTSLineage_WriteToReposIfAvailable = $00000002;
  DTSLineage_WriteToReposRequired = $00000003;

// Constants for enum DTSFastLoadOptions
type
  DTSFastLoadOptions = TOleEnum;
const
  DTSFastLoad_NoOptions = $00000000;
  DTSFastLoad_KeepNulls = $00000001;
  DTSFastLoad_CheckConstraints = $00000002;
  DTSFastLoad_TableLock = $00000004;
  DTSFastLoad_Default = $00000002;

// Constants for enum DTSTransformationSetOptions
type
  DTSTransformationSetOptions = TOleEnum;
const
  DTSTranSetOpt_Flattened = $00000000;
  DTSTranSetOpt_Hierarchical = $00000001;
  DTSTranSetOpt_DataDrivenQueries = $00000004;
  DTSTranSetOpt_Default = $00000000;

// Constants for enum DTSPackageType
type
  DTSPackageType = TOleEnum;
const
  DTSPkgType_Default = $00000000;
  DTSPkgType_DTSWizard = $00000001;
  DTSPkgType_DTSDesigner = $00000002;
  DTSPkgType_SQLReplication = $00000003;
  DTSPkgType_ActiveDirectory = $00000004;

// Constants for enum DTSExceptionFileOptions
type
  DTSExceptionFileOptions = TOleEnum;
const
  DTSExcepFile_SingleFile70 = $00000001;
  DTSExcepFile_ErrorFile = $00000002;
  DTSExcepFile_SourceRowFile = $00000004;
  DTSExcepFile_DestRowFile = $00000008;
  DTSExcepFile_Ansi = $00000100;
  DTSExcepFile_OEM = $00000200;
  DTSExcepFile_Unicode = $00000400;
  DTSExcepFile_Overwrite = $00001000;
  DTSExcepFile_AbortOnRowLogFailure = $00002000;

// Constants for enum DTSDesignerSettings
type
  DTSDesignerSettings = TOleEnum;
const
  DTSDesigner_Default = $00000000;
  DTSDesigner_ShowMultiPhaseTransforms = $00000001;

type

// *********************************************************************//
// Forward declaration of types defined in TypeLibrary                    
// *********************************************************************//
  IDTSStdObject = interface;
  IDTSStdObjectDisp = dispinterface;
  Properties = interface;
  PropertiesDisp = dispinterface;
  Property_ = interface;
  Property_Disp = dispinterface;
  _Package = interface;
  _PackageDisp = dispinterface;
  Steps = interface;
  StepsDisp = dispinterface;
  Step = interface;
  StepDisp = dispinterface;
  PrecedenceConstraints = interface;
  PrecedenceConstraintsDisp = dispinterface;
  PrecedenceConstraint = interface;
  PrecedenceConstraintDisp = dispinterface;
  Tasks = interface;
  TasksDisp = dispinterface;
  Task = interface;
  TaskDisp = dispinterface;
  CustomTask = interface;
  CustomTaskDisp = dispinterface;
  Connections = interface;
  ConnectionsDisp = dispinterface;
  Connection = interface;
  ConnectionDisp = dispinterface;
  OleDBProperties = interface;
  OleDBPropertiesDisp = dispinterface;
  OleDBProperty = interface;
  OleDBPropertyDisp = dispinterface;
  GlobalVariables = interface;
  GlobalVariablesDisp = dispinterface;
  GlobalVariable = interface;
  GlobalVariableDisp = dispinterface;
  SavedPackageInfos = interface;
  SavedPackageInfosDisp = dispinterface;
  SavedPackageInfo = interface;
  SavedPackageInfoDisp = dispinterface;
  _PropertiesProvider = interface;
  _PropertiesProviderDisp = dispinterface;
  Step2 = interface;
  Step2Disp = dispinterface;
  ActiveScriptTask = interface;
  ActiveScriptTaskDisp = dispinterface;
  DataPumpTask = interface;
  DataPumpTaskDisp = dispinterface;
  Transformations = interface;
  TransformationsDisp = dispinterface;
  Transformation = interface;
  TransformationDisp = dispinterface;
  Columns = interface;
  ColumnsDisp = dispinterface;
  Column = interface;
  ColumnDisp = dispinterface;
  Lookups = interface;
  LookupsDisp = dispinterface;
  Lookup = interface;
  LookupDisp = dispinterface;
  DataPumpTask2 = interface;
  DataPumpTask2Disp = dispinterface;
  CreateProcessTask = interface;
  CreateProcessTaskDisp = dispinterface;
  CreateProcessTask2 = interface;
  CreateProcessTask2Disp = dispinterface;
  ExecuteSQLTask = interface;
  ExecuteSQLTaskDisp = dispinterface;
  DataDrivenQueryTask = interface;
  DataDrivenQueryTaskDisp = dispinterface;
  DataDrivenQueryTask2 = interface;
  DataDrivenQueryTask2Disp = dispinterface;
  TransferObjectsTask = interface;
  TransferObjectsTaskDisp = dispinterface;
  TransferObjectsTask2 = interface;
  TransferObjectsTask2Disp = dispinterface;
  SendMailTask = interface;
  SendMailTaskDisp = dispinterface;
  BulkInsertTask = interface;
  BulkInsertTaskDisp = dispinterface;
  GlobalVariable2 = interface;
  GlobalVariable2Disp = dispinterface;
  OleDBProperty2 = interface;
  OleDBProperty2Disp = dispinterface;
  Connection2 = interface;
  Connection2Disp = dispinterface;
  Transformation2 = interface;
  Transformation2Disp = dispinterface;
  PropertyBag = interface;
  PropertyBagDisp = dispinterface;
  PersistPropertyBag = interface;
  PersistPropertyBagDisp = dispinterface;
  PackageEvents = interface;
  PackageLog = interface;
  PackageLogDisp = dispinterface;
  ParallelDataPumpTask = interface;
  ParallelDataPumpTaskDisp = dispinterface;
  TransformationSets = interface;
  TransformationSetsDisp = dispinterface;
  TransformationSet = interface;
  TransformationSetDisp = dispinterface;
  ExecutePackageTask = interface;
  ExecutePackageTaskDisp = dispinterface;
  TaskInfos = interface;
  TaskInfosDisp = dispinterface;
  TaskInfo = interface;
  TaskInfoDisp = dispinterface;
  TransformationInfos = interface;
  TransformationInfosDisp = dispinterface;
  TransformationInfo = interface;
  TransformationInfoDisp = dispinterface;
  ScriptingLanguageInfos = interface;
  ScriptingLanguageInfosDisp = dispinterface;
  ScriptingLanguageInfo = interface;
  ScriptingLanguageInfoDisp = dispinterface;
  OLEDBProviderInfos = interface;
  OLEDBProviderInfosDisp = dispinterface;
  OLEDBProviderInfo = interface;
  OLEDBProviderInfoDisp = dispinterface;
  PackageSQLServer = interface;
  PackageSQLServerDisp = dispinterface;
  PackageLogRecords = interface;
  PackageLogRecordsDisp = dispinterface;
  PackageLogRecord = interface;
  PackageLogRecordDisp = dispinterface;
  StepLogRecords = interface;
  StepLogRecordsDisp = dispinterface;
  StepLogRecord = interface;
  StepLogRecordDisp = dispinterface;
  TaskLogRecords = interface;
  TaskLogRecordsDisp = dispinterface;
  TaskLogRecord = interface;