EnumPackageInfos Method

DTS Programming

DTS Programming

EnumPackageInfos Method

The EnumPackageInfos method returns a PackageInfos collection containing information about all the packages stored in Microsoft® SQL Server™ 2000 Meta Data Services or in SQL Server storage that satisfy the criteria of the input parameters.

Applies To
PackageRepository Object PackageSQLServer Object
Syntax

Set collection = object.EnumPackageInfos(
    PackageName,
    ReturnLatest,
    PackageID
)

Part Description
collection Expression that evaluates to a PackageInfos collection
object Expression that evaluates to an object in the Applies To list
PackageName A string specifying the package name to which the collection is to be limited
ReturnLatest A Boolean specifying whether only the latest version of each package is to be included in the collection
PackageID A globally unique identifier (GUID) string specifying the package ID to which the collection is to be limited

Remarks

All parameters are required. To return information on all packages in Meta Data Services or in SQL Server storage, code the empty string "" for PackageName and PackageID, and FALSE for ReturnLatest.

The syntax of GUIDs is:

{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}

Where the X's are hexadecimal digits. The groupings are 8, 4, 4, 4, and 12 digits. The curly brackets are required. Spaces cannot be embedded for readability.

Prototype (C/C++)

HRESULT EnumPackageInfos(
    BSTR PackageName,
    VARIANT_BOOL ReturnLatest,
    BSTR PackageID,
    IDTSPackageInfos **pRetVal );

See Also

PackageID Property

PackageInfos Collection

PackageName Property

Retrieving DTS System, Package, and Log Data