⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 dts_tlb.pas

📁 delphi使用sqlserver2000中dts导入导出数据
💻 PAS
📖 第 1 页 / 共 5 页
字号:
unit DTS_TLB;

// ************************************************************************ //
// WARNING                                                                    
// -------                                                                    
// The types declared in this file were generated from data read from a       
// Type Library. If this type library is explicitly or indirectly (via        
// another type library referring to this type library) re-imported, or the   
// 'Refresh' command of the Type Library Editor activated while editing the   
// Type Library, the contents of this file will be regenerated and all        
// manual modifications will be lost.                                         
// ************************************************************************ //

// PASTLWTR : $Revision:   1.130.1.0.1.0.1.6  $
// File generated on 2006-6-10 20:43:03 from Type Library described below.

// ************************************************************************  //
// Type Lib: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll (1)
// LIBID: {10010001-EB1C-11CF-AE6E-00AA004A34D5}
// LCID: 0
// Helpfile: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldts80.hlp
// DepndLst: 
//   (1) v2.0 stdole, (C:\WINNT\System32\stdole2.tlb)
//   (2) v4.0 StdVCL, (C:\WINNT\System32\stdvcl40.dll)
// Errors:
//   Hint: TypeInfo 'Property' changed to 'Property_'
//   Hint: Member 'Type' of 'Property' changed to 'Type_'
//   Hint: Member 'Set' of 'Property' changed to 'Set_'
//   Hint: Parameter 'Object' of Steps.Add changed to 'Object_'
//   Hint: Parameter 'Object' of Steps.Insert changed to 'Object_'
//   Hint: Parameter 'Object' of PrecedenceConstraints.Add changed to 'Object_'
//   Hint: Parameter 'Object' of PrecedenceConstraints.Insert changed to 'Object_'
//   Hint: Parameter 'Object' of Tasks.Add changed to 'Object_'
//   Hint: Parameter 'Object' of Tasks.Insert changed to 'Object_'
//   Hint: Parameter 'Object' of Connections.Add changed to 'Object_'
//   Hint: Parameter 'Object' of Connections.Insert changed to 'Object_'
//   Hint: Parameter 'Object' of GlobalVariables.Add changed to 'Object_'
//   Hint: Parameter 'Object' of GlobalVariables.Insert changed to 'Object_'
//   Hint: Parameter 'Object' of Transformations.Add changed to 'Object_'
//   Hint: Parameter 'Object' of Transformations.Insert changed to 'Object_'
//   Hint: Parameter 'Object' of Columns.Add changed to 'Object_'
//   Hint: Parameter 'Object' of Columns.Insert changed to 'Object_'
//   Hint: Parameter 'Object' of Lookups.Add changed to 'Object_'
//   Hint: Parameter 'Object' of Lookups.Insert changed to 'Object_'
//   Hint: Parameter 'Type' of TransferObjectsTask.AddObjectForTransfer changed to 'Type_'
//   Hint: Parameter 'Type' of TransferObjectsTask.GetObjectForTransfer changed to 'Type_'
//   Hint: Parameter 'Object' of TransformationSets.Add changed to 'Object_'
//   Hint: Parameter 'Object' of TransformationSets.Insert changed to 'Object_'
//   Error creating palette bitmap of (TPackage) : Server C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll contains no icons
//   Error creating palette bitmap of (TPackage2) : Server C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll contains no icons
//   Error creating palette bitmap of (TPropertiesProvider) : Server C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll contains no icons
//   Error creating palette bitmap of (TApplication) : Server C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll contains no icons
// ************************************************************************ //
// *************************************************************************//
// NOTE:                                                                      
// Items guarded by $IFDEF_LIVE_SERVER_AT_DESIGN_TIME are used by properties  
// which return objects that may need to be explicitly created via a function 
// call prior to any access via the property. These items have been disabled  
// in order to prevent accidental use from within the object inspector. You   
// may enable them by defining LIVE_SERVER_AT_DESIGN_TIME or by selectively   
// removing them from the $IFDEF blocks. However, such items must still be    
// programmatically created via a method of the appropriate CoClass before    
// they can be used.                                                          
{$TYPEDADDRESS OFF} // Unit must be compiled without type-checked pointers. 
{$WARN SYMBOL_PLATFORM OFF}
{$WRITEABLECONST ON}
{$VARPROPSETTER ON}
interface

uses Windows, ActiveX, Classes, Graphics, OleServer, StdVCL, Variants;
  

// *********************************************************************//
// GUIDS declared in the TypeLibrary. Following prefixes are used:        
//   Type Libraries     : LIBID_xxxx                                      
//   CoClasses          : CLASS_xxxx                                      
//   DISPInterfaces     : DIID_xxxx                                       
//   Non-DISP interfaces: IID_xxxx                                        
// *********************************************************************//
const
  // TypeLibrary Major and minor versions
  DTSMajorVersion = 2;
  DTSMinorVersion = 0;

  LIBID_DTS: TGUID = '{10010001-EB1C-11CF-AE6E-00AA004A34D5}';

  IID_IDTSStdObject: TGUID = '{10010004-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Properties: TGUID = '{10020001-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Property_: TGUID = '{10020002-EB1C-11CF-AE6E-00AA004A34D5}';
  IID__Package: TGUID = '{10020205-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Steps: TGUID = '{10020302-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Step: TGUID = '{10020305-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PrecedenceConstraints: TGUID = '{10020B05-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PrecedenceConstraint: TGUID = '{10020B06-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Tasks: TGUID = '{10020905-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Task: TGUID = '{10020906-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_CustomTask: TGUID = '{10020904-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Connections: TGUID = '{10020C05-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Connection: TGUID = '{10020C06-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_OleDBProperties: TGUID = '{10020E05-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_OleDBProperty: TGUID = '{10020E06-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_GlobalVariables: TGUID = '{10020A05-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_GlobalVariable: TGUID = '{10020A07-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_SavedPackageInfos: TGUID = '{10020F05-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_SavedPackageInfo: TGUID = '{10020F06-EB1C-11CF-AE6E-00AA004A34D5}';
  IID__PropertiesProvider: TGUID = '{10020206-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Step2: TGUID = '{10020306-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_ActiveScriptTask: TGUID = '{10020907-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_DataPumpTask: TGUID = '{10020908-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Transformations: TGUID = '{10020D05-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Transformation: TGUID = '{10020D06-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Columns: TGUID = '{10020402-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Column: TGUID = '{10020405-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Lookups: TGUID = '{10020502-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Lookup: TGUID = '{10020505-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_DataPumpTask2: TGUID = '{1002090A-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_CreateProcessTask: TGUID = '{10020909-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_CreateProcessTask2: TGUID = '{10020914-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_ExecuteSQLTask: TGUID = '{1002090C-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_DataDrivenQueryTask: TGUID = '{1002090D-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_DataDrivenQueryTask2: TGUID = '{1002090B-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TransferObjectsTask: TGUID = '{1002090E-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TransferObjectsTask2: TGUID = '{10020913-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_SendMailTask: TGUID = '{1002090F-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_BulkInsertTask: TGUID = '{10020910-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_GlobalVariable2: TGUID = '{10020A08-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_OleDBProperty2: TGUID = '{10020E07-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Connection2: TGUID = '{10020C07-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_Transformation2: TGUID = '{10020D07-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PropertyBag: TGUID = '{10021005-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PersistPropertyBag: TGUID = '{10021006-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageEvents: TGUID = '{10020605-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageLog: TGUID = '{10020706-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_ParallelDataPumpTask: TGUID = '{10020911-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TransformationSets: TGUID = '{10021105-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TransformationSet: TGUID = '{10021106-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_ExecutePackageTask: TGUID = '{10020912-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TaskInfos: TGUID = '{10030101-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TaskInfo: TGUID = '{10030110-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TransformationInfos: TGUID = '{10030201-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TransformationInfo: TGUID = '{10030210-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_ScriptingLanguageInfos: TGUID = '{10030301-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_ScriptingLanguageInfo: TGUID = '{10030310-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_OLEDBProviderInfos: TGUID = '{10030401-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_OLEDBProviderInfo: TGUID = '{10030410-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageSQLServer: TGUID = '{10030510-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageLogRecords: TGUID = '{10030701-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageLogRecord: TGUID = '{10030710-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_StepLogRecords: TGUID = '{10030801-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_StepLogRecord: TGUID = '{10030810-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TaskLogRecords: TGUID = '{10030901-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_TaskLogRecord: TGUID = '{10030910-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageInfos: TGUID = '{10030601-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageInfo: TGUID = '{10030610-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageRepository: TGUID = '{10030520-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageLineages: TGUID = '{10030A01-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_PackageLineage: TGUID = '{10030A10-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_StepLineages: TGUID = '{10030B01-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_StepLineage: TGUID = '{10030B10-EB1C-11CF-AE6E-00AA004A34D5}';
  IID__Package2: TGUID = '{10020207-EB1C-11CF-AE6E-00AA004A34D5}';
  CLASS_Package: TGUID = '{10020200-EB1C-11CF-AE6E-00AA004A34D5}';
  CLASS_Package2: TGUID = '{10020202-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_ExecuteSQLTask2: TGUID = '{10020915-EB1C-11CF-AE6E-00AA004A34D5}';
  IID_CustomTaskUI: TGUID = '{10022005-EB1C-11CF-AE6E-00AA004A34D5}';
  CLASS_PropertiesProvider: TGUID = '{10020201-EB1C-11CF-AE6E-00AA004A34D5}';
  IID__Application: TGUID = '{10030001-EB1C-11CF-AE6E-00AA004A34D5}';
  CLASS_Application: TGUID = '{10030000-EB1C-11CF-AE6E-00AA004A34D5}';

// *********************************************************************//
// Declaration of Enumerations defined in Type Library                    
// *********************************************************************//
// Constants for enum DTSPackageError
type
  DTSPackageError = TOleEnum;
const
  DTSPackage_E_NotImplemented = $000003E9;
  DTSPackage_E_OrdOutOfRange = $000003EA;
  DTSPackage_E_NameNotFound = $000003EB;
  DTSPackage_E_NameDup = $000003EC;
  DTSPackage_E_NoStepsDefined = $000003ED;
  DTSPackage_E_Column_OutOfRange = $000003EE;
  DTSPackage_E_ColumnNeedsNameOrOrdinal = $000003EF;
  DTSPackage_E_WrongCollection = $000003F0;
  DTSPackage_E_DatatypeNotFound = $000003F1;
  DTSPackage_E_NeedConnectionInfo = $000003F2;
  DTSPackage_E_ODBC_NeedConnectionInfo = $000003F3;
  DTSPackage_E_NoStepsToExecute = $000003F4;
  DTSPackage_E_DescribeNeedsQuery = $000003F5;
  DTSPackage_E_ColumnsNotDescribed = $000003F6;
  DTSPackage_E_Step_CyclicDependency = $000003F7;
  DTSPackage_E_UsageBeforeDescribeOnly = $000003F8;
  DTSPackage_E_AxScript_CantInitializeEngine = $000003F9;
  DTSPackage_E_AxScript_RequiredParams = $000003FA;
  DTSPackage_E_AxScript_ParseError = $000003FB;
  DTSPackage_E_AxScript_BadFunctionName = $000003FC;
  DTSPackage_E_AxScript_CantAddGlobals = $000003FD;
  DTSPackage_E_AxScript_RunTimeError = $000003FE;
  DTSPackage_E_BadStepStatusValue = $000003FF;
  DTSPackage_E_BadStepResultValue = $00000400;
  DTSPackage_E_BadTaskResultValue = $00000401;
  DTSPackage_E_BadPrecedenceBasis = $00000402;
  DTSPackage_E_BadStepTask = $00000403;
  DTSPackage_E_RequireConnectionProperties = $00000404;
  DTSPackage_E_ConnectionRequiresValidTaskName = $00000405;
  DTSPackage_E_ConnectionInUse = $00000406;
  DTSPackage_E_CannotFindConnection = $00000407;
  DTSPackage_E_PumpTask_RequireXforms = $00000408;
  DTSPackage_E_PumpTask_RequireSrcAndDestColumns = $00000409;
  DTSPackage_E_PumpTask_RequireRowsetDataSrcInfo = $0000040A;
  DTSPackage_E_PumpTask_RequireXformServer = $0000040B;
  DTSPackage_E_BadPrecedenceStep = $0000040C;
  DTSPackage_E_CreateProcTask_Timeout = $0000040D;
  DTSPackage_E_BadGUIDValue = $0000040E;
  DTSPackage_E_RequireNameForExecOrStg = $0000040F;
  DTSPackage_E_CantFindVersionInStg = $00000410;
  DTSPackage_E_CantSetCommandProps = $00000411;
  DTSPackage_E_BadPriorityClass = $00000412;
  DTSPackage_E_BadRelativePriority = $00000413;
  DTSPackage_E_CantFindPackageInStg = $00000414;
  DTSPackage_E_EncryptStg_CantCreateOrWrite = $00000415;
  DTSPackage_E_EncryptStg_CantOpenOrRead = $00000416;
  DTSPackage_E_EncryptStg_HandsOnStg = $00000417;
  DTSPackage_E_EncryptStg_UnsupportedFlags = $00000418;
  DTSPackage_E_EncryptStg_PasswordNotMatching = $00000419;
  DTSPackage_E_EncryptStg_RequirePassword = $0000041A;
  DTSPackage_E_EncryptStg_StreamTooLarge = $0000041B;
  DTSPackage_E_Security_InvalidPassword = $0000041C;
  DTSPackage_E_Security_RequireBothPasswords = $0000041D;
  DTSPackage_E_Security_OperatorNotPriveleged = $0000041E;
  DTSPackage_E_SQLTask_RequireSQL = $0000041F;
  DTSPackage_E_UnknownOleDBProperty = $00000420;
  DTSPackage_E_RequireConnectionID = $00000421;
  DTSPackage_E_RequireColumnNameAndOrdinal = $00000422;
  DTSPackage_E_PropertyStringTooLong = $00000423;
  DTSPackage_E_CantChangeLoadedPkgName = $00000424;
  DTSPackage_E_NoXformDispatch = $00000425;
  DTSPackage_E_CannotPersistProperty = $00000426;
  DTSPackage_E_ExecutionCanceled = $00000427;
  DTSPackage_E_FailedOnStepError = $00000428;
  DTSPackage_E_BadForceMode = $00000429;
  DTSPackage_E_MultiPackageStgNeedsID = $0000042A;
  DTSPackage_E_BadSQLServerStorageFlags = $0000042B;
  DTSPackage_E_NoPackageDataFromServer = $0000042C;
  DTSPackage_E_NeedDestinationColumnDefinitions = $0000042D;
  DTSPackage_E_DSO_OnlyOneSession = $0000042E;
  DTSPackage_E_DSO_OnlyOneRowset = $0000042F;
  DTSPackage_E_DSO_ProviderStringRequired = $00000430;
  DTSPackage_E_DSO_CantRelaunchPackage = $00000431;
  DTSPackage_E_DSO_OnlyOneCommand = $00000432;
  DTSPackage_E_BadPackageDSORowsetTask = $00000433;
  DTSPackage_E_AbandonedRowQueueDest = $00000434;
  DTSPackage_E_DataDrivenQueryTask_RequireXforms = $00000435;
  DTSPackage_E_NeedDataDrivenQueries = $00000436;

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -