PackageInfos PackageInfos PackageInfos Class

Definition

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

public ref class PackageInfos sealed : Microsoft::SqlServer::Dts::Runtime::DTSReadOnlyCollectionBase
public sealed class PackageInfos : Microsoft.SqlServer.Dts.Runtime.DTSReadOnlyCollectionBase
Public NotInheritable Class PackageInfos
Inherits DTSReadOnlyCollectionBase
Inheritance

Examples

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

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

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.

Properties

Count Count Count

Gets the number of elements contained in the DTSReadOnlyCollectionBase instance.

(Inherited from DTSReadOnlyCollectionBase)
IsSynchronized IsSynchronized IsSynchronized

Gets a value that indicates whether access to the DTSReadOnlyCollectionBase is synchronized (thread-safe).

(Inherited from DTSReadOnlyCollectionBase)
Item[Object] Item[Object] Item[Object]

Retrieves the PackageInfo object from the collection.

SyncRoot SyncRoot SyncRoot

Gets an object that can be used to synchronize access to the DTSReadOnlyCollectionBase.

(Inherited from DTSReadOnlyCollectionBase)

Methods

Contains(Object) Contains(Object) Contains(Object)

Returns a Boolean that indicates whether an object can be retrieved from the collection by using the name, index, GUID, or description parameter.

CopyTo(Array, Int32) CopyTo(Array, Int32) CopyTo(Array, Int32)

Copies the entire DTSReadOnlyCollectionBase to a compatible one-dimensional array, starting at the specified index of the target array.

(Inherited from DTSReadOnlyCollectionBase)
CreateManagedObject(Object) CreateManagedObject(Object) CreateManagedObject(Object)

Creates managed object from an unmanaged object.

(Inherited from DTSReadOnlyCollectionBase)
GetCount() GetCount() GetCount()

Retrieves the number of objects in the collection.

(Inherited from DTSReadOnlyCollectionBase)
GetEnumerator() GetEnumerator() GetEnumerator()

Returns an enumerator for use in iterating over the PackageInfos collection.

GetManagedEnumerator(Object) GetManagedEnumerator(Object) GetManagedEnumerator(Object)

Gets the managed enumerator from an unmanaged enumerator.

(Inherited from DTSReadOnlyCollectionBase)

Fields

m_unmanagedColl m_unmanagedColl m_unmanagedColl

The unmanaged collection.

(Inherited from DTSReadOnlyCollectionBase)

Applies to