RemoveFromSQLServer Method (DTS)

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

Applies To
Package Object  

Syntax

object.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 username
ServerPassword Server user password
bTrustedConnection Whether to use a trusted connection
PackagePassword Package password if the package is encrypted
PackageVersionGuid Package identifier, which is a string representation of a GUID
PackageName Version identifier, which is a string representation of a GUID
  Package name

Remarks

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

Prototype (C/C++)

HRESULT RemoveFromSQLServer(BSTR ServerName,
BSTR ServerUserName,
BSTR ServerPassword,
VARIANT_BOOL bTrustedConnection,
BSTR PackageGuid,
BSTR PackageVersionGuid,
BSTR PackageName);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.