DTS Programming

Package Object

The Package object is the main transformation-defining object from which all other objects stem.

Collections
Connections Collection Steps Collection
GlobalVariables Collection Tasks Collection
Properties Collection  

Properties
AutoCommitTransaction Property PackageID Property
CreationDate Property PackagePriorityClass Property
CreatorComputerName Property Parent Property
CreatorName Property RepositoryMetadataOptions Property
Description Property TransactionIsolationLevel Property
FailOnError Property UseOLEDBServiceComponents Property
LineageOptions Property UseTransaction Property
LogFileName Property VersionID Property
MaxConcurrentSteps Property WriteCompletionStatusToNTEventLog Property
Name Property  

Methods
Execute Method RemoveFromRepository Method
GetDTSVersionInfo Method RemoveFromSQLServer Method
GetLastExecutionLineage Method SaveAs Method
GetSavedPackageInfos Method SaveToRepository Method
LoadFromRepository Method SaveToSQLServer Method
LoadFromSQLServer Method SaveToStorageFile Method
LoadFromStorageFile Method  

Events
OnError Event OnQueryCancel Event
OnFinish Event OnStart Event
OnProgress Event  

Remarks

The Package object is compatible with Microsoft® SQL Server™ version 7.0. For more information about an extended version of this object, see Package2 Object.

See Also

Creating DTS Package Objects and Connections