Export (0) Print
Expand All

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)

'Declaration
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 function RemoveFromSqlServer (
	packagePath : String, 
	serverName : String, 
	serverUserName : String, 
	serverPassword : String
)

Parameters

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.

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.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft