Application.RemoveFromSqlServer(String, String, String, String) Metode

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Menghapus paket dari instans SQL Server yang ditentukan.

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

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

member this.RemoveFromSqlServer : string * string * string * string -> unit

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

Parameter

packagePath

String

Nama paket yang akan dihapus.

serverName

String

Nama instans SQL Server.

serverUserName

String

Nama pengguna yang akan digunakan saat mengautentikasi terhadap server.

serverPassword

String

Kata sandi yang serverUserName terkait dengan akun.

Contoh

Contoh kode berikut menghapus paket bernama myNewName yang disimpan sebelumnya.

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