Programming DTS Applications
    Extended DTS Objects
    DTS Object Model Diagram
       DTS Package2 Hierarchy
       Pump Task Elements
       Pump Rowset Elements
       Data Driven Query Elements
       DTS Application Hierarchy
    Creating DTS Packages with the DTS Object Model
       Creating DTS Package Objects and Connections
       Creating DTS Package Workflow and Tasks
       Adding DTS Transformations
       Adding DTS Column Objects
       Adding DTS Lookups and Global Variables
       Adding DTS ActiveX Scripts
       Adding DTS Query Strings
       Handling DTS Events and Errors
       Managing DTS Package Programs
       Retrieving DTS System, Package, and Log Data
    Creating DTS Packages in Visual Basic
       Creating DTS Objects in Visual Basic
          DTS Packages in Visual Basic
          DTS Connections in Visual Basic
          DTS Package Workflow in Visual Basic
          DTS Tasks in Visual Basic
          DTS Transformations in Visual Basic
          DTS Column Objects in Visual Basic
          DTS Lookups in Visual Basic
          DTS Global Variables in Visual Basic
          DTS ActiveX Scripts in Visual Basic
          DTS Query Strings in Visual Basic
          DTS Package Events in Visual Basic
       Managing DTS Package Programs in Visual Basic
          Executing DTS Packages in Visual Basic
          Handling DTS Errors in Visual Basic
          Saving DTS Packages in Visual Basic
          Running a DTS Package Saved as a Visual Basic File
          Retrieving DTS Information in Visual Basic
    Building a DTS Custom Task
       DTS Custom Task Fundamentals
       Including a DTS Custom Task User Interface
       Registering a DTS Custom Task
       Additional DTS Custom Task Features
          Raising Events from a DTS Custom Task
          Writing Log Data from a DTS Custom Task
          Using the DTS Custom Task Properties Provider
       DTS Custom Task Examples in Visual Basic
          DTS Example: Basic Custom Task in Visual Basic
          DTS Example: Adding Properties and Icons in Visual Basic
          DTS Example: Including a User Interface in Visual Basic
          DTS Example: Running Concurrent Operations in Visual Basic
       Implementing DTS Custom Tasks in Visual C++
          Building a DTS Custom Task from a Standard ATL Template
          Building a DTS Custom Task from the ATL Custom Task Basic Template
          Adding a DTS User Interface to the Custom Task Framework
          Building a DTS Custom Task with a User Interface from the ATL Custom Task Templates
          Implementing and Testing a DTS Custom Task
       DTS Custom Task Examples in Visual C++
          DTS Example: Adding Properties and Icons in Visual C++
          DTS Example: Including a User Interface in Visual C++
             Creating the Custom Task Framework
             Implementing the Property Page and Display Dialog Box
             Implementing the Task Class
             Implementing the User Interface Class
             Implementing the Property Page Class
             Implementing the Display Dialog Class
             Building and Running the DTS Custom Task User Interface Example in Visual C++
    Building a DTS Custom Transformation
       DTS Custom Transformation Fundamentals
          COM DLL Infrastructure
          IDTSDataPumpTransform Interface
          IDTSDataPumpTransform2 Interface
          Column Information Structures in DTS Transformations
          Registration Requirements for DTS Transformations
       Implementing DTS Custom Transformations
          Building a Custom Transformation from a Standard ATL Template
          Building a Custom Transformation from the ATL Custom Transformation Template
          Implementing and Testing a DTS Custom Transformation
       DTS Custom Transformation Examples
          DTS Custom Transformation Example: Copy One Column
          DTS Custom Transformation Example: Format Names
 DTS Scripting Reference
    Scripting Objects
       DTSDataPumpColumn Object
       DTSDataPumpColumn2 Object
       DTSDataPumpLookup Object
       DTSTransformPhaseInfo Object
    Scripting Collections
       DTSDataPumpColumns Collection
       DTSDataPumpLookups Collection
       DTSErrorRecords Collection
    Scripting Properties
       ActualSize Property
       Attributes Property
       Count Property
       CurrentPhase Property
       CurrentSourceRow Property
       DefinedSize Property
       DestinationRowsComplete Property
       ErrorRows Property
       LastRowCount Property
       Name Property
       NumericScale Property
       OriginalValue Property
       Precision Property
       Status Property
       TransformStatus Property
       Type Property
       UnderlyingValue Property
       Value Property
    Scripting Methods
       Add Method
       AddToCache Method
       AppendChunk Method
       Clear Method
       Execute Method
       GetChunk Method
       Item Method
       RemoveFromCache Method
    Scripting Constants
 DTS Programming Reference
    Task Objects
       ActiveScriptTask Object
       BulkInsertTask Object
       CreateProcessTask Object
       CreateProcessTask2 Object
       DataDrivenQueryTask Object
       DataDrivenQueryTask2 Object
       DataPumpTask Object
       DataPumpTask2 Object
       DynamicPropertiesTask Object
       ExecutePackageTask Object
       ExecuteSQLTask Object
       ExecuteSQLTask2 Object
       DTSFTPTask Object
       DTSMessageQueueTask Object
       ParallelDataPumpTask Object
          Hierarchical Rowsets
          Parallel Data Pump Example
          Parallel Data Driven Query Example
       SendMailTask Object
       TransferObjectsTask Object
       TransferObjectsTask2 Object
    Transformation Objects
       DataPumpTransformCopy Object
       DataPumpTransformDateTimeString Object
       DataPumpTransformLowerString Object
       DataPumpTransformMidString Object
       DataPumpTransformReadFile Object
       DataPumpTransformScript Object
       DataPumpTransformTrimString Object
       DataPumpTransformUpperString Object
       DataPumpTransformWriteFile Object
       DTSTransformScriptProperties2 Object
          Phased Transformation Samples
    Other Objects
       Application Object
       Column Object
       Connection Object
       Connection2 Object
       CustomTask Object
       CustomTaskUI Object
       DTSMQMessage Object
       DynamicPropertiesTaskAssignment Object
       GlobalVariable Object
       GlobalVariable2 Object
       IDTSStdObject
       Lookup Object
       OLEDBProperty Object
       OLEDBProperty2 Object
       OLEDBProviderInfo Object
       Package Object
       Package2 Object
       PackageInfo Object
       PackageLineage Object
       PackageLog Object
       PackageLogRecord Object
       PackageRepository Object
       PackageSQLServer Object
       PersistPropertyBag Object
       PrecedenceConstraint Object
       PropertiesProvider Object
       Property Object
       PropertyBag Object
       SavedPackageInfo Object
       ScriptingLanguageInfo Object
       Step Object
       Step2 Object
       StepLineage Object
       StepLogRecord Object
       Task Object
       TaskInfo Object
       TaskLogRecord Object
       Transformation Object
       Transformation2 Object
       TransformationInfo Object
       TransformationSet Object
    Collections
       Columns Collection
       Connections Collection
       DTSMQMessages Collection
       DynamicPropertiesTaskAssignments Collection
       GlobalVariables Collection
       Lookups Collection
       OLEDBProperties Collection
       OLEDBProviderInfos Collection
       PackageInfos Collection
       PackageLineages Collection
       PackageLogRecords Collection
       PrecedenceConstraints Collection
       Properties Collection
       SavedPackageInfos Collection
       ScriptingLanguageInfos Collection
       StepLineages Collection
       StepLogRecords Collection
       Steps Collection
       TaskInfos Collection
       TaskLogRecords Collection
       Tasks Collection
       TransformationInfos Collection
       Transformations Collection
       TransformationSets Collection
    Properties
       ActiveXScript Property
       AddGlobalVariables Property
       AllowIdentityInserts Property
       AMSymbol Property
       AppendIfFileExists Property
       Assignments Property
       AutoCommitTransaction Property
       BatchCompleteFunctionEntry Property
       BatchSize Property
       Catalog Property
       CCLine Property
       CharacterCount Property
       CharacterStart Property
       CheckConstraints Property
       ClassID Property
       CloseConnection Property
       Codepage Property
       ColumnID Property
       CommandProperties Property
       CommandTimeout Property
       CommitSuccess Property
       Computer Property
       Connected Property
       ConnectImmediate Property
       ConnectionID Property
       ConnectionProperties Property
       ConnectionTimeout Property
       CopyAllObjects Property
       CopyData Property
       CopySchema Property
       Count Property
       CreationDate Property
       CreatorComputerName Property
       CreatorName Property
       CustomTask Property
       CustomTaskID Property
       DataFile Property
       DataFileNonOverwritable Property
       DataFileType Property
       DataPumpOptions Property
       DataSource Property
       DataType Property
       Day?LongName Property
       Day?ShortName Property
       DeleteQuery Property
       DeleteQueryColumns Property
       Description Property
       DesignerSettings Property
       DestinationColumnDefinitions Property
       DestinationColumns Property
       DestinationCommandProperties Property
       DestinationConnectionID Property
       DestinationDatabase Property
       DestinationLogin Property
       DestinationObjectName Property
       DestinationPassword Property
       DestinationPropertyID Property
       DestinationServer Property
       DestinationSQLStatement Property
       DestinationTableName Property
       DestinationUseTrustedConnection Property
       DestSite Property
       DestTranslateChar Property
       DestUseTransaction Property
       DisableStep Property
       DropDestinationObjectsFirst Property
       DTSMessageLineageID Property
       DTSMessagePackageID Property
       DTSMessageVersionID Property
       EOF Property
       ErrorCode Property
       ErrorDescription Property
       ErrorHelpContext Property
       ErrorHelpFile Property
       ErrorIfFileExists Property
       ErrorIfFileNotFound Property
       ErrorIfReceiveMessageTimeout Property
       ErrorSource Property
       ExceptionFileColumnDelimiter Property
       ExceptionFileName Property
       ExceptionFileOptions Property
       ExceptionFileRowDelimiter Property
       ExceptionFileTextQualifier Property
       ExecuteInMainThread Property
       ExecutionDate Property
       ExecutionResult Property
       ExecutionStatus Property
       ExecutionTime Property
       ExplicitGlobalVariables Property
       FailOnError Property
       FailPackageOnError Property
       FailPackageOnLogFailure Property
       FailPackageOnTimeout Property
       FastLoadOptions Property
       FetchBufferSize Property
       FieldTerminator Property
       FileAttachments Property
       FileColumnName Property
       FileName Property
       FilePath Property
       FinishTime Property
       FirstRow Property
       Flags Property
       ForceBlobsInMemory Property
       ForceSourceBlobsBuffered Property
       FormatFile Property
       FunctionEntry Property
       FunctionName Property
       Get Property
       IconFile Property
       IconIndex Property
       ID Property
       ImplementationFileName Property
       ImplementationFileVersionString Property
       IncludeDependencies Property
       IncludeLogins Property
       IncludeUsers Property
       InMemoryBlobSize Property
       InputFormat Property
       InputGlobalVariableNames Property
       InsertCommitSize Property
       InsertFailureFunctionEntry Property
       InsertQuery Property
       InsertQueryColumns Property
       InsertSuccessFunctionEntry Property
       InTransaction Property
       InUse Property
       IsDefaultValue Property
       IsNTService Property
       IsOwner Property
       IsPackageDSORowset Property
       IsVersionEncrypted Property
       JITDebug Property
       JoinTransactionIfPresent Property
       KeepIdentity Property
       KeepNulls Property
       Language Property
       LastOwnerTaskName Property
       LastRow Property
       LineageFullID Property
       LineageOptions Property
       LineageShortID Property
       LogDate Property
       LogFileName Property
       LogServerFlags Property
       LogServerName Property
       LogServerPassword Property
       LogServerUserName Property
       LogToSQLServer Property
       LowerCaseString Property
       MaxCacheRows Property
       MaxConcurrentSteps Property
       MaximumErrorCount Property
       MaximumErrors Property
       MessageDataFile Property
       MessageGlobalVariables Property
       MessageString Property
       MessageText Property
       MessageType Property
       Month??LongName Property
       Month??ShortName Property
       Name Property
       NestedExecutionLevel Property
       NonOverwritable Property
       Nullable Property
       NumericScale Property
       NumRetriesOnSource Property
       OEMFile Property
       Operator Property
       Ordinal Property
       OutputAsRecordset Property
       OutputFormat Property
       OutputGlobalVariableNames Property
       Owner Property
       PackageCreationDate Property
       PackageDataSize Property
       PackageID Property
       PackageName Property
       PackagePassword Property
       PackagePriorityClass Property
       PackageType Property
       Parent Property
       ParseName Property
       Password Property
       PMSymbol Property
       PostSourceDataFunctionEntry Property
       PrecedenceBasis Property
       Precision Property
       PreSourceDataFunctionEntry Property
       ProcessCommandLine Property
       Profile Property
       ProgressCount Property
       ProgressRowCount Property
       PropertyID Property
       PropertySet Property
       ProviderID Property
       PumpCompleteFunctionEntry Property
       Query Property
       QueuePath Property
       ReceiveMessageTimeout Property
       ReceiveMessageType Property
       RelativePriority Property
       RemoveFromQueue Property
       RepositoryDatabaseName Property
       RepositoryMetadataOptions Property
       Reusable Property
       RollbackFailure Property
       RowsComplete Property
       RowsInError Property
       RowTerminator Property
       SaveDataFileName Property
       SaveMailInSentItemsFolder Property
       ScriptFileDirectory Property
       ScriptLanguage Property
       ScriptOption Property
       ScriptOptionEx Property
       SequenceID Property
       ServerName Property
       ServerPassword Property
       ServerUserName Property
       Set Property
       ShortYear2000Cutoff Property
       Size Property
       SortedData Property
       SourceColumns Property
       SourceCommandProperties Property
       SourceConnectionID Property
       SourceConstantValue Property
       SourceDatabase Property
       SourceDataFileFileName Property
       SourceEnvironmentVariable Property
       SourceFilename Property
       SourceGlobalVariable Property
       SourceIniFileFileName Property
       SourceIniFileKey Property
       SourceIniFileSection Property
       SourceLocation Property
       SourceLogin Property
       SourceObjectName Property
       SourcePassword Property
       SourcePassword (DTSFTPTask) Property
       SourceQueryConnectionID Property
       SourceQuerySQL Property
       SourceServer Property
       SourceSite Property
       SourceSQLStatement Property
       SourceTranslateChar Property
       SourceType Property
       SourceUsername Property
       SourceUseTrustedConnection Property
       SQLStatement Property
       StartTime Property
       StepExecutionID Property
       StepExecutionResult Property
       StepExecutionStatus Property
       StepName Property
       StringCompareType Property
       StringCompareValue Property
       Subject Property
       SuccessReturnCode Property
       TableLock Property
       TaskName Property
       TaskType Property
       TerminateProcessAfterTimeout Property
       Text Property
       Timeout Property
       ToLine Property
       TransactionIsolationLevel Property
       TransformationSetOptions Property
       TransformFailureFunctionEntry Property
       TransformFlags Property
       TransformPhases Property
       TransformServer Property
       TransformServerID Property
       TransformServerParameter Property
       TransformServerProperties Property
       TrimEmbeddedWhiteSpace Property
       TrimLeadingWhiteSpace Property
       TrimTrailingWhiteSpace Property
       Type Property
       UDLPath Property
       UnicodeFile Property
       UpdateQuery Property
       UpdateQueryColumns Property
       UpperCaseString Property
       UseCache Property
       UseCollation Property
       UseFastLoad Property
       UseOLEDBServiceComponents Property
       UseRepository Property
       UserID Property
       UserQuery Property
       UserQueryColumns Property
       UseTransaction Property
       UseTransaction (DTSMQMessage) Property
       UseTrustedConnection Property
       Value Property
       VersionID Property
       VersionSaveDate Property
       WaitForAcknowledgement Property
       WriteCompletionStatusToNTEventLog Property
    Methods
       AcquireConnection Method
       Add Method
       AddColumn Method
       AddConstraint Method
       AddGlobalVariable Method
       AddLookup Method
       AddObjectForTransfer Method
       BeginAcquireMultipleConnections Method
       CancelExecution Method
       CheckSyntax Method
       CreateCustomToolTip Method
       Delete Method
       Edit Method
       EndAcquireMultipleConnections Method
       EnumPackageInfos Method
       EnumPackageLineages Method
       EnumPackageLogRecords Method
       EnumStepLineages Method
       EnumStepLogRecords Method
       EnumTaskLogRecords Method
       Execute Method
       Execute (Package) Method
       GetDayLongName Method
       GetDayShortName Method
       GetDefaultProfileName Method
       GetDTSVersionInfo Method
       GetExecutionErrorInfo Method
       GetExpandedProcessCommandLine Method
       GetLastExecutionLineage Method
       GetMonthLongName Method
       GetMonthShortName Method
       GetObjectForTransfer Method
       GetPackageRepository Method
       GetPackageSQLServer Method
       GetPropertiesForObject Method
       GetSavedPackageInfos Method
       GetUIInfo Method
       Help Method
       Initialize Method
       InitializeMAPI Method
       Insert Method
       Item Method
       Load Method
       LoadFromRepository Method
       LoadFromSQLServer Method
       LoadFromStorageFile Method
       Lock Method
       Logoff Method
       Logon Method
       Messages Method
       New Method
       New (Columns) Method
       New (CustomTaskUI) Method
       New (ID) Method
       New (Name) Method
       NewDataLink Method
       Next Method
       Read Method
       Refresh Method
       ReleaseConnection Method
       Remove Method
       RemoveAllLogRecords Method
       RemoveFromRepository Method
       RemoveFromSQLServer Method
       RemovePackageLineages Method
       RemovePackageLogRecords Method
       RemoveStepLogRecords Method
       RemoveTaskLogRecords Method
       Reset Method
       ResetObjectsList Method
       ResolveName Method
       Save Method
       SaveAs Method
       SaveToRepository Method
       SaveToRepositoryAs Method
       SaveToSQLServer Method
       SaveToSQLServerAs Method
       SaveToStorageFile Method
       SaveToStorageFileAs Method
       SetDayLongName Method
       SetDayShortName Method
       SetMonthLongName Method
       SetMonthShortName Method
       ShowAddressBook Method
       Uninitialize Method
       UninitializeMAPI Method
       Unlock Method
       Write Method
       WriteStringToLog Method
       WriteTaskRecord Method
    Events
       OnError Event
       OnFinish Event
       OnProgress Event
       OnQueryCancel Event
       OnStart Event
    Constants
       DTSBulkInsert_DataFileType
       DTSCustomTaskUIFlags
       DTSDataPumpError
       DTSDesignerSettings
       DTSExceptionFileOptions
       DTSExecuteStatus
       DTSFastLoadOptions
       DTSForceMode
       DTSFTPError
       DTSFTPSourceLocation
       DTSIsolationLevel
       DTSLineageOptions
       DTSMQMessageType
       DTSMQStringMessageCompare
       DTSMQType
       DTSMSMQError
       DTSPackageError
       DTSPackagePriorityClass
       DTSPackageType
       DTSRepositoryMetadataOptions
       DTSRepositoryStorageFlags
       DTSSQLObjectType
       DTSSQLServerStorageFlags
       DTSStepExecResult
       DTSStepExecStatus
       DTSStepPrecedenceBasis
       DTSStepRelativePriority
       DTSStepScriptResult
       DTSTaskExecResult
       DTSTransfer_CopyDataOption
       DTSTransfer_ScriptOption
       DTSTransfer_ScriptOptionEx
       DTSTransformationSetOptions
       DTSTransformFlags
       DTSTransformPhaseEnum
       DTSTransformStatus
       DynamicPropertiesTaskError
       DynamicPropertiesTaskSourceType
 Data Pump Interfaces
    IDTSDataPump
       IDTSDataPump::AddTransform
       IDTSDataPump::AddTransformVariable
       IDTSDataPump::Execute
       IDTSDataPump::GetRowsets
       IDTSDataPump::InitNew
       IDTSDataPump::SetFetchBufferSize
       IDTSDataPump::SetInsertCommitSize
       IDTSDataPump::SetMaximumErrorRowCount
       IDTSDataPump::SetProgressRowCount
       IDTSDataPump::SetRowsets
    IDTSDataPump2
       IDTSDataPump2::AddTransform2
       IDTSDataPump2::ExecuteComplete
       IDTSDataPump2::ExecuteInit
       IDTSDataPump2::ExecuteRow
       IDTSDataPump2::GetExecuteInfo
       IDTSDataPump2::GetOptions
       IDTSDataPump2::SetExecuteThreadComplete
       IDTSDataPump2::SetOptions
    IDTSDataPumpErrorSink
       IDTSDataPumpErrorSink::OnBindingError
       IDTSDataPumpErrorSink::OnDestinationError
       IDTSDataPumpErrorSink::OnSourceError
       IDTSDataPumpErrorSink::OnTransformError
    IDTSDataPumpProgressSink
       IDTSDataPumpProgressSink::OnIntervalComplete
    IDTSDataPumpTransform
       IDTSDataPumpTransform::AddVariable
       IDTSDataPumpTransform::Execute
       IDTSDataPumpTransform::Initialize
       IDTSDataPumpTransform::OnRowComplete
       IDTSDataPumpTransform::OnTransformComplete
       IDTSDataPumpTransform::ValidateSchema
    IDTSDataPumpTransform2
       IDTSDataPumpTransform2::GetTransformServerInfo
       IDTSDataPumpTransform2::PreValidateSchema
       IDTSDataPumpTransform2::ProcessPhase
       IDTSDataPumpTransform2::SetExecuteThreadComplete
       IDTSDataPumpTransform2::SetExtendedInfo
    Transform Status Enumerations
 DTS Programming Samples
    CustomTaskNoUI
    CustomTaskWithUI
    CustomTransform
    DTS Custom Transformation Sample
    DTS Custom Task
    DTSCopy
    DTSStrings
    DTSTskGVUpdate
    DTSTskPropIcon
    Packages
    Complex Transformation Sample from SQL Server to Excel
    DTS Package Sample Supporting Multiple Source and Destination Providers
    DTSActiveScriptTask
    DTSApplicationObject
    DTSAppObject
    DTSBulkInsertTask
    DTSCopyDatabase
    DTSExecProcess
    DTSExecSQLTask
    DTSExecutePackage
    DTSFTPTask
    DTSPackageInfo
    DTSTransferObjectsTask
    FoodMart2000
    Pub2Pubs
    Simple DTS Package Sample Using Visual Basic
    Simple Transformation Sample Between Two SQL Server Tables