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.
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.