RemoveFromSQLServer Method

DTS Programming

DTS Programming

RemoveFromSQLServer Method

The RemoveFromSQLServer method removes the package from the specified server running an instance of Microsoft® SQL Server™.

Applies To
Package Object Package2 Object
Syntax

Package.RemoveFromSQLServer ServerName, [ServerUserName], _
    [ServerPassword], [Flags], [PackageGuid], _
    [PackageVersionGuid], [PackageName]

Part Description
Package Expression that evaluates to an object in the Applies To list.
ServerName Server name.
ServerUserName Server user name.
ServerPassword Server user password.
Flags Value from the DTSSQLServerStorageFlags constants indicating user authentication type.
PackageGuid Package identifier, which is a string representation of a globally unique identifier (GUID).
PackageVersionGuid Version identifier, which is a string representation of a GUID.
PackageName Package name.

Remarks

If PackageVersionGUID is not specified or is blank, the most recent version of the package is removed.

Prototype (C/C++)

HRESULT RemoveFromSQLServer(
    BSTR ServerName,
    BSTR ServerUserName,
    BSTR ServerPassword,
    DTSSQLServerStorageFlags Flags CPPDEFAULT(= DTSSQLStgFlag_Default),
    BSTR PackageGuid CPPDEFAULT(= NULL),
    BSTR PackageVersionGuid CPPDEFAULT(= NULL),
    BSTR PackageName CPPDEFAULT(= NULL) );

See Also

DTSSQLServerStorageFlags

LoadFromSQLServer Method

Managing DTS Package Programs

SaveToSQLServer Method

SaveToSQLServerAs Method