PackageInfos Class

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

Inheritance Hierarchy

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

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

Syntax

'Declaration
Public NotInheritable Class PackageInfos _
    Inherits DTSReadOnlyCollectionBase
'Usage
Dim instance As PackageInfos

public sealed class PackageInfos : DTSReadOnlyCollectionBase

public ref class PackageInfos sealed : public DTSReadOnlyCollectionBase

[<SealedAttribute>]
type PackageInfos =  
    class
        inherit DTSReadOnlyCollectionBase
    end

public final class PackageInfos extends DTSReadOnlyCollectionBase

The PackageInfos type exposes the following members.

Properties

	Name	Description
	Count	Gets the number of elements contained in the DTSReadOnlyCollectionBase instance. (Inherited from DTSReadOnlyCollectionBase.)
	IsSynchronized	Gets a value that indicates whether access to the DTSReadOnlyCollectionBase is synchronized (thread-safe). (Inherited from DTSReadOnlyCollectionBase.)
	Item	Retrieves the PackageInfo object from the collection.
	SyncRoot	Gets an object that can be used to synchronize access to the DTSReadOnlyCollectionBase. (Inherited from DTSReadOnlyCollectionBase.)

Top

Methods

	Name	Description
	Contains	Returns a Boolean that indicates whether an object can be retrieved from the collection by using the name, index, GUID, or description parameter.
	CopyTo	Copies the entire DTSReadOnlyCollectionBase to a compatible one-dimensional array, starting at the specified index of the target array. (Inherited from DTSReadOnlyCollectionBase.)
	CreateManagedObject	Infrastructure. (Inherited from DTSReadOnlyCollectionBase.)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetCount	Infrastructure. (Inherited from DTSReadOnlyCollectionBase.)
	GetEnumerator	Returns an enumerator for use in iterating over the PackageInfos collection.
	GetHashCode	(Inherited from Object.)
	GetManagedEnumerator	Infrastructure. (Inherited from DTSReadOnlyCollectionBase.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)

Top

Fields

	Name	Description
	m_unmanagedColl	Infrastructure. (Inherited from DTSReadOnlyCollectionBase.)

Top

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.

Examples

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 Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Dts.Runtime Namespace