DTS Programming
PackageSQLServer Object
The PackageSQLServer object provides access to the Data Transformation Services (DTS) components hosted by an instance of Microsoft® SQL Server™. Through methods of this object, you can obtain information about the DTS packages stored in SQL Server storage and access the contents of the package, step, and task log records stored on that server.
Properties
| Name Property | Properties Collection |
| Parent Property |
Methods
| EnumPackageInfos Method | RemoveAllLogRecords Method |
| EnumPackageLogRecords Method | RemovePackageLogRecords Method |
| EnumStepLogRecords Method | RemoveStepLogRecords Method |
| EnumTaskLogRecords Method |
Remarks
Access the PackageSQLServer object by using the GetPackageSQLServer method of the Application object. Provide the necessary login information to access the instance of SQL Server you want.