Поделиться через


Метод Application.RemoveFromSqlServer

Removes a package from the specified instance of SQL Server.

Пространство имен:  Microsoft.SqlServer.Dts.Runtime
Сборка:  Microsoft.SqlServer.ManagedDTS (в Microsoft.SqlServer.ManagedDTS.dll)

Синтаксис

'Декларация
Public Sub RemoveFromSqlServer ( _
    packagePath As String, _
    serverName As String, _
    serverUserName As String, _
    serverPassword As String _
)
'Применение
Dim instance As Application 
Dim packagePath As String 
Dim serverName As String 
Dim serverUserName As String 
Dim serverPassword As String

instance.RemoveFromSqlServer(packagePath, _
    serverName, serverUserName, serverPassword)
public void RemoveFromSqlServer(
    string packagePath,
    string serverName,
    string serverUserName,
    string serverPassword
)
public:
void RemoveFromSqlServer(
    String^ packagePath, 
    String^ serverName, 
    String^ serverUserName, 
    String^ serverPassword
)
member RemoveFromSqlServer : 
        packagePath:string * 
        serverName:string * 
        serverUserName:string * 
        serverPassword:string -> unit
public function RemoveFromSqlServer(
    packagePath : String, 
    serverName : String, 
    serverUserName : String, 
    serverPassword : String
)

Параметры

  • packagePath
    Тип: System.String
    The name of the package to remove.
  • serverName
    Тип: System.String
    The name of the instance of SQL Server.
  • serverUserName
    Тип: System.String
    The user name to use when authenticating against the server.
  • serverPassword
    Тип: System.String
    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

См. также

Справочник

Application Класс

Пространство имен Microsoft.SqlServer.Dts.Runtime