通过

Application.RemoveFromSqlServer Method

  • 项目

Removes a package from the specified instance of SQL Server.

命名空间: Microsoft.SqlServer.Dts.Runtime
程序集: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

语法

声明
Public Sub RemoveFromSqlServer ( _
    packagePath As String, _
    serverName As String, _
    serverUserName As String, _
    serverPassword As String _
)

public void RemoveFromSqlServer (
    string packagePath,
    string serverName,
    string serverUserName,
    string serverPassword
)

public:
void RemoveFromSqlServer (
    String^ packagePath, 
    String^ serverName, 
    String^ serverUserName, 
    String^ serverPassword
)

public void RemoveFromSqlServer (
    String packagePath, 
    String serverName, 
    String serverUserName, 
    String serverPassword
)

public function RemoveFromSqlServer (
    packagePath : String, 
    serverName : String, 
    serverUserName : String, 
    serverPassword : String
)

参数

  • packagePath
    The name of the package to remove.
  • serverName
    The name of the instance of SQL Server.
  • serverUserName
    The user name to use when authenticating against the server.
  • serverPassword
    The password associated with the ServerUserName account.

示例

The following code example removes a package named myNewName that was saved previously.

static void Main(string[] args)
{
    Application app = new Application();
    // The package was previously saved using this method call.
    //app.SaveToSqlServerAs(p1, null, "myNewName", "yourserver", null, null);

    // Remove the previously saved package.
    app.RemoveFromSqlServer("myNewName", "yourserver", null, null);
}

Shared  Sub Main(ByVal args() As String)
    Dim app As Application =  New Application() 
    ' The package was previously saved using this method call.
    'app.SaveToSqlServerAs(p1, null, "myNewName", "yourserver", null, null);
 
    ' Remove the previously saved package.
    app.RemoveFromSqlServer("myNewName", "yourserver", Nothing, Nothing)
End Sub

线程安全

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

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

Application Class
Application Members
Microsoft.SqlServer.Dts.Runtime Namespace