Udostępnij za pośrednictwem


Application.RemoveFromDtsServer Method

Removes a package from the specified server.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public Sub RemoveFromDtsServer ( _
    sPackagePath As String, _
    sServerName As String _
)
public void RemoveFromDtsServer (
    string sPackagePath,
    string sServerName
)
public:
void RemoveFromDtsServer (
    String^ sPackagePath, 
    String^ sServerName
)
public void RemoveFromDtsServer (
    String sPackagePath, 
    String sServerName
)
public function RemoveFromDtsServer (
    sPackagePath : String, 
    sServerName : String
)

Parameters

  • sPackagePath
    The fully qualified path of the package.
  • sServerName
    The name of the server where the package is located.

Remarks

To verify that the package no longer exists, you can open the Integration Services service, select the File System, and click Refresh. The package is no longer listed.

Example

The following code example removes a package named myp1Package.

static void Main(string[] args)
{
    Application app = new Application();
    app.RemoveFromDtsServer(@"File System\myp1Package", "yourserver");
}
Shared  Sub Main(ByVal args() As String)
    Dim app As Application =  New Application() 
    app.RemoveFromDtsServer("File System\myp1Package", "yourserver")
End Sub

Thread Safety

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.

Platforms

Development Platforms

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

Target Platforms

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

See Also

Reference

Application Class
Application Members
Microsoft.SqlServer.Dts.Runtime Namespace