TechNet
Export (0) Print
Expand All

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)

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

[DefaultMemberAttribute("Item")]
public sealed class PackageInfos : DTSReadOnlyCollectionBase

NameDescription
System_CAPS_pubpropertyCount

Gets the number of elements contained in the DTSReadOnlyCollectionBase instance.(Inherited from DTSReadOnlyCollectionBase.)

System_CAPS_pubpropertyIsSynchronized

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

System_CAPS_pubpropertyItem[Object]

Retrieves the PackageInfo object from the collection.

System_CAPS_pubpropertySyncRoot

Gets an object that can be used to synchronize access to the DTSReadOnlyCollectionBase.(Inherited from DTSReadOnlyCollectionBase.)

NameDescription
System_CAPS_pubmethodContains(Object)

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

System_CAPS_pubmethodCopyTo(Array, Int32)

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

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetEnumerator()

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

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodToString()

(Inherited from Object.)

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.

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

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

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

Return to top
Show:
© 2016 Microsoft