Application.RemoveFromSqlServer Method
Removes a package from the specified instance of SQL Server.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Sub RemoveFromSqlServer ( _
packagePath As String, _
serverName As String, _
serverUserName As String, _
serverPassword As String _
)
'Usage
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
)
Parameters
- packagePath
Type: System.String
The name of the package to remove.
- serverName
Type: System.String
The name of the instance of SQL Server.
- serverUserName
Type: System.String
The SQL Server login name if you use SQL Server Authentication to log into the server; otherwise, nulla null reference (Nothing in Visual Basic) if you use Windows Authentication.
- serverPassword
Type: System.String
The SQL Server login password if you use SQL Server Authentication to log into the server; otherwise, nulla null reference (Nothing in Visual Basic) if you use Windows Authentication.
Examples
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