dts_tlb.pas

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

  DTSPackage_E_NeedDataDrivenQueryAndColumns = $00000437;
  DTSPackage_E_HostFailedPersistence = $00000438;
  DTSPackage_E_BadLookupConnectionProvider = $00000439;
  DTSPackage_E_CreateProcessNullCommandLine = $0000043A;
  DTSPackage_E_GeneralTaskFailure = $0000043B;
  DTSPackage_E_XfrTask_SrcInfoIncomplete = $0000043C;
  DTSPackage_E_XfrTask_DestInfoIncomplete = $0000043D;
  DTSPackage_E_XfrTask_InvalidCopyDataOption = $0000043E;
  DTSPackage_E_XfrTask_InvalidObjectType = $0000043F;
  DTSPackage_E_XfrTask_InvalidObjectName = $00000440;
  DTSPackage_E_XfrTask_InvalidOwnerName = $00000441;
  DTSPackage_E_XfrTask_CantCreateDMOObject = $00000442;
  DTSPackage_E_XfrTask_CantConnectToSrc = $00000443;
  DTSPackage_E_XfrTask_CantGetSrcDB = $00000444;
  DTSPackage_E_XfrTask_IndexOutOfRange = $00000445;
  DTSPackage_E_BadStepScriptResultValue = $00000446;
  DTSPackage_E_AxScript_CantModifyDuringExecute = $00000447;
  DTSPackage_E_Repos_NotRegistered = $0000044C;
  DTSPackage_E_Repos_CantScanCatalog = $0000044D;
  DTSPackage_E_Repos_ScannedObjectNotFound = $0000044E;
  DTSPackage_E_Repos_ScannedColumnNotFound = $0000044F;
  DTSPackage_E_Repos_BadStorageFlags = $00000450;
  DTSPackage_E_Repos_CantParseName = $00000451;
  DTSPackage_E_Repos_ScannedSchemaNotFound = $00000452;
  DTSPackage_E_Repos_UnscannedColumnNotFound = $00000453;
  DTSPackage_E_Repos_DuplicatePackageName = $00000454;
  DTSPackage_E_Repos_ScanRequiresSchemaRowset = $00000455;
  DTSPackage_E_Repos_GeneralError = $00000456;
  DTSPackage_E_Repos_InvalidMetadataOptions = $00000457;
  DTSPackage_E_Repos_PackageNotFound = $00000458;
  DTSPackage_E_Repos_CantSaveToOldModel = $00000459;
  DTSPackage_E_Lineage_BadOptions = $00000460;
  DTSPackage_E_Lineage_NoRepositoryContext = $00000461;
  DTSPackage_E_Lineage_CantOpenRepository = $00000462;
  DTSPackage_E_Lineage_RepositoryError = $00000463;
  DTSPackage_E_Lineage_PackageVersionFrozen = $00000464;
  DTSPackage_E_Lineage_ErrorWritingToRepos = $00000465;
  DTSPackage_E_Trx_InvalidIsolationLevel = $0000046A;
  DTSPackage_E_Trx_TaskCannotJoinTransaction = $0000046B;
  DTSPackage_E_Trx_ConnCannotJoinTransaction = $0000046C;
  DTSPackage_E_Trx_BeginFailed = $0000046D;
  DTSPackage_E_Trx_StepCommitFailed = $0000046E;
  DTSPackage_E_Trx_PackageCommitFailed = $0000046F;
  DTSPackage_E_Trx_DTCNotAvailable = $00000470;
  DTSPackage_E_Trx_TrxNoLongerActive = $00000471;
  DTSPackage_E_Trx_ExternalTrxAborted = $00000472;
  DTSPackage_E_MailTask_NoMAPIInterfaceLayer = $0000047E;
  DTSPackage_E_MailTask_CantInitializeMAPI = $0000047F;
  DTSPackage_E_MailTask_LogonFailure = $00000480;
  DTSPackage_E_MailTask_SendFailure = $00000481;
  DTSPackage_E_MailTask_NotInitialized = $00000482;
  DTSPackage_E_MailTask_GeneralFailure = $00000483;
  DTSPackage_E_BulkInsertTask_RequireTableName = $00000484;
  DTSPackage_E_BulkInsertTask_RequireDataFile = $00000485;
  DTSPackage_E_InvalidFastLoadOptions = $00000492;
  DTSPackage_E_EncryptStg_CantInit = $00000493;
  DTSPackage_E_NoFastLoadWithDataLink = $00000494;
  DTSPackage_E_NoFastLoad = $00000495;
  DTSPackage_E_ProcTaskReturnCodeNotSuccess = $00000496;
  DTSPackage_E_SaveTo70OrLater = $00000497;
  DTSPackage_E_SQLServerLicenseError = $00000498;
  DTSPackage_E_GlobalVariableObjectPersistSave = $00000499;
  DTSPackage_E_GlobalVariableObjectPersistLoad = $0000049A;
  DTSPackage_E_BadTransformFlags = $0000049C;
  DTSPackage_E_InvalidTransformationSetOptions = $000004B0;
  DTSPackage_E_TransformSet_RequireXforms = $000004B1;
  DTSPackage_E_TransformSet_RequireSrcRowset = $000004B2;
  DTSPackage_E_ParallelPumpTask_RequireTransformationSets = $000004B3;
  DTSPackage_E_TransformSet_HierarchyMismatch = $000004B4;
  DTSPackage_E_TransformSet_RequireDestRowset = $000004B5;
  DTSPackage_E_TransformSet_CantFindIndexName = $000004B6;
  DTSPackage_E_CantSetPropsWithConnectionOpen = $000004E2;
  DTSPackage_E_ProcTask_InvalidEnvVar = $000004E3;
  DTSPackage_E_LogServerInfoIncomplete = $000004E4;
  DTSPackage_E_CantDoNTEventLog = $000004E5;
  DTSPackage_E_CantCreateLogFile = $000004E6;
  DTSPackage_E_CantConnectToLogServer = $000004E7;
  DTSPackage_E_ErrorWritingtoLogServer = $000004E8;
  DTSPackage_E_InvalidPackageType = $000004E9;
  DTSPackage_E_InvalidExceptionFileOptions = $000004EA;
  DTSPackage_E_BadTransformPhase = $000004EB;
  DTSPackage_E_DSO_NeedStepName = $000004EC;
  DTSPackage_E_DSO_NoSteps = $000004ED;
  DTSPackage_E_DSO_CantGetStepMetadata = $000004EE;
  DTSPackage_E_DSO_BadCommand = $000004EF;
  DTSPackage_E_DSO_RequiredPropFailed = $000004F0;
  DTSPackage_E_DSO_StepWasSkipped = $000004F1;
  DTSPackage_E_DSO_ProviderNoSchemaRowsets = $000004F2;
  DTSPackage_E_DSO_NoDestinationObjectSpec = $000004F3;
  DTSPackage_E_BadDataPumpOption = $00000500;
  DTSPackage_E_AxScript_CantAddPackageLog = $00000501;
  DTSPackage_E_InvalidDesignerSetting = $00000502;
  DTSPackage_E_NoMoreRecords = $00000503;
  DTSPackage_E_NotPackageStorageFile = $00000504;
  DTSPackage_E_NestedExecutionLimit = $00000505;
  DTSPackage_E_CannotReadUplevelPackage = $00000506;
  DTSPackage_E_NameCannotBeSetEmpty = $00000507;
  DTSPackage_E_Method_Timeout = $00000508;
  DTSPackage_E_ThreadNotLockOwner = $00000509;
  DTSPackage_E_CantSaveTo64BitSQLServer = $0000050A;
  DTSPackage_E_CantLoadFrom64BitSQLServer = $0000050B;

// Constants for enum DTSStepExecStatus
type
  DTSStepExecStatus = TOleEnum;
const
  DTSStepExecStat_Waiting = $00000001;
  DTSStepExecStat_InProgress = $00000002;
  DTSStepExecStat_Inactive = $00000003;
  DTSStepExecStat_Completed = $00000004;

// Constants for enum DTSStepExecResult
type
  DTSStepExecResult = TOleEnum;
const
  DTSStepExecResult_Success = $00000000;
  DTSStepExecResult_Failure = $00000001;

// Constants for enum DTSStepScriptResult
type
  DTSStepScriptResult = TOleEnum;
const
  DTSStepScriptResult_ExecuteTask = $00000000;
  DTSStepScriptResult_DontExecuteTask = $00000001;
  DTSStepScriptResult_RetryLater = $00000002;

// Constants for enum DTSTaskExecResult
type
  DTSTaskExecResult = TOleEnum;
const
  DTSTaskExecResult_Success = $00000000;
  DTSTaskExecResult_Failure = $00000001;
  DTSTaskExecResult_RetryStep = $00000002;

// Constants for enum DTSStepPrecedenceBasis
type
  DTSStepPrecedenceBasis = TOleEnum;
const
  DTSStepPrecedenceBasis_ExecStatus = $00000000;
  DTSStepPrecedenceBasis_ExecResult = $00000001;

// Constants for enum DTSStepRelativePriority
type
  DTSStepRelativePriority = TOleEnum;
const
  DTSStepRelativePriority_Lowest = $00000001;
  DTSStepRelativePriority_BelowNormal = $00000002;
  DTSStepRelativePriority_Normal = $00000003;
  DTSStepRelativePriority_AboveNormal = $00000004;
  DTSStepRelativePriority_Highest = $00000005;

// Constants for enum DTSPackagePriorityClass
type
  DTSPackagePriorityClass = TOleEnum;
const
  DTSPriorityClass_Low = $00000001;
  DTSPriorityClass_Normal = $00000002;
  DTSPriorityClass_High = $00000003;

// Constants for enum DTSIsolationLevel
type
  DTSIsolationLevel = TOleEnum;
const
  DTSIsoLevel_Chaos = $00000010;
  DTSIsoLevel_ReadUncommitted = $00000100;
  DTSIsoLevel_Browse = $00000100;
  DTSIsoLevel_CursorStability = $00001000;
  DTSIsoLevel_ReadCommitted = $00001000;
  DTSIsoLevel_RepeatableRead = $00010000;
  DTSIsoLevel_Serializable = $00100000;
  DTSIsoLevel_Isolated = $00100000;

// Constants for enum DTSForceMode
type
  DTSForceMode = TOleEnum;
const
  DTSForceMode_Default = $00000000;
  DTSForceMode_Always = $00000001;
  DTSForceMode_Never = $00000002;

// Constants for enum DTSCustomTaskUIFlags
type
  DTSCustomTaskUIFlags = TOleEnum;
const
  DTSCustomTaskUIFlags_Default = $00000000;
  DTSCustomTaskUIFlags_DoesCustomToolTip = $00000001;

// Constants for enum DTSRepositoryStorageFlags
type
  DTSRepositoryStorageFlags = TOleEnum;
const
  DTSReposFlag_Default = $00000000;
  DTSReposFlag_UseTrustedConnection = $00000100;

// Constants for enum DTSSQLServerStorageFlags
type
  DTSSQLServerStorageFlags = TOleEnum;
const
  DTSSQLStgFlag_Default = $00000000;
  DTSSQLStgFlag_UseTrustedConnection = $00000100;

// Constants for enum DTSRepositoryMetadataOptions
type
  DTSRepositoryMetadataOptions = TOleEnum;
const
  DTSReposMetadata_Default = $00000000;
  DTSReposMetadata_RequireScannedCatalog = $00000001;
  DTSReposMetadata_UseScannedCatalogIfPresent = $00000002;
  DTSReposMetadata_ScanCatalogIfNotFound = $00000004;
  DTSReposMetadata_ScanCatalogAlways = $00000008;

// Constants for enum DTSSQLObjectType
type
  DTSSQLObjectType = TOleEnum;
const
  DTSSQLObj_UserDefinedDatatype = $00000001;
  DTSSQLObj_SystemTable = $00000002;
  DTSSQLObj_View = $00000004;
  DTSSQLObj_UserTable = $00000008;
  DTSSQLObj_StoredProcedure = $00000010;
  DTSSQLObj_Default = $00000040;
  DTSSQLObj_Rule = $00000080;
  DTSSQLObj_Trigger = $00000100;
  DTSSQLObj_UserDefinedFunction = $00001000;
  DTSSQLObj_AllDatabaseUserObjects = $000011FD;
  DTSSQLObj_AllDatabaseObjects = $000011FF;

// Constants for enum DTSTransfer_CopyDataOption
type
  DTSTransfer_CopyDataOption = TOleEnum;
const
  DTSTransfer_DontCopyData = $00000000;
  DTSTransfer_ReplaceData = $00000001;
  DTSTransfer_AppendData = $00000002;

// Constants for enum DTSTransfer_ScriptOption
type
  DTSTransfer_ScriptOption = TOleEnum;
const
  DTSTransfer_Script_Default = $00000004;
  DTSTransfer_Script_Drops = $00000001;
  DTSTransfer_Script_ObjectPermissions = $00000002;
  DTSTransfer_Script_PrimaryObject = $00000004;
  DTSTransfer_Script_ClusteredIndexes = $00000008;
  DTSTransfer_Script_Triggers = $00000010;
  DTSTransfer_Script_DatabasePermissions = $00000020;
  DTSTransfer_Script_Permissions = $00000022;
  DTSTransfer_Script_ToFileOnly = $00000040;
  DTSTransfer_Script_Bindings = $00000080;
  DTSTransfer_Script_AppendToFile = $00000100;
  DTSTransfer_Script_NoDRI = $00000200;
  DTSTransfer_Script_UDDTsToBaseType = $00000400;
  DTSTransfer_Script_IncludeIfNotExists = $00001000;