Table of contents
-
Programming DTS Applications
- Extended DTS Objects
- DTS Object Model Diagram
-
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
-
Creating DTS Objects 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
- DTS Custom Task Examples 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 Scripting Reference
- Scripting Objects
- Scripting Collections
-
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
- 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
- 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
-
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
-
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
-
Task Objects
- Data Pump Interfaces
-
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