Udostępnij za pośrednictwem


PackageInfos Class

Contains a collection of packages found in Microsoft SQL Server or the Integration Services service. This class cannot be inherited.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
<DefaultMemberAttribute("Item")> _
Public NotInheritable Class PackageInfos
    Inherits DTSReadOnlyCollectionBase
[DefaultMemberAttribute("Item")] 
public sealed class PackageInfos : DTSReadOnlyCollectionBase
[DefaultMemberAttribute(L"Item")] 
public ref class PackageInfos sealed : public DTSReadOnlyCollectionBase
/** @attribute DefaultMemberAttribute("Item") */ 
public final class PackageInfos extends DTSReadOnlyCollectionBase
DefaultMemberAttribute("Item") 
public final class PackageInfos extends DTSReadOnlyCollectionBase

Remarks

This collection enumerates packages. You can retrieve packages that are stored in the Integration Services service and then iterate through them, or you can retrieve packages that are stored in SQL Server. For a sample of how to retrieve Integration Services service packages programmatically, see GetDtsServerPackageInfos. For information about retrieving SQL Server packages programmatically, see GetPackageInfos.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Dts.Runtime.DTSReadOnlyCollectionBase
    Microsoft.SqlServer.Dts.Runtime.PackageInfos

Example

The following code example instantiates a PackageInfos object from the Application object.

PackageInfos pInfos = app.GetDtsServerPackageInfos(@"File System", "YOURSERVER");

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

PackageInfos Members
Microsoft.SqlServer.Dts.Runtime Namespace