Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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)
public void RemoveFromSqlServer(
	string packagePath,
	string serverName,
	string serverUserName,
	string serverPassword
)

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, null 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, null if you use Windows Authentication.

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);
}
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.