Application.RemoveFolderFromSqlServer Method
Removes the specified folder from the specified instance of SQL Server.
Espacio de nombres: Microsoft.SqlServer.Dts.Runtime
Ensamblado: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Sintaxis
'Declaración
Public Sub RemoveFolderFromSqlServer ( _
strFolderName As String, _
strServerName As String, _
strServerUserName As String, _
strServerPassword As String _
)
public void RemoveFolderFromSqlServer (
string strFolderName,
string strServerName,
string strServerUserName,
string strServerPassword
)
public:
void RemoveFolderFromSqlServer (
String^ strFolderName,
String^ strServerName,
String^ strServerUserName,
String^ strServerPassword
)
public void RemoveFolderFromSqlServer (
String strFolderName,
String strServerName,
String strServerUserName,
String strServerPassword
)
public function RemoveFolderFromSqlServer (
strFolderName : String,
strServerName : String,
strServerUserName : String,
strServerPassword : String
)
Parámetros
- strFolderName
The name of the folder to delete.
- strServerName
The name of the instance of SQL Server to remove the folder from.
- strServerUserName
The user name to authenticate against the instance of SQL Server.
- strServerPassword
The password for the specified strServerUserName.
Ejemplo
The following code example creates a folder on SQL Server, renames it, and then removes it by using RemoveFolderFromSqlServer. It also verifies the existence of the folder several times by using FolderExistsOnSqlServer.
[C#]
static void Main(string[] args)
{
// The variable pkg points to the location
// of the ExecuteProcess package sample
// that is installed with the SSIS samples.
string pkg = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
Application app = new Application();
app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", null, null);
// Verify that the folder was created.
Boolean ssFolder = app.FolderExistsOnSqlServer("\\myNewFolder", "yourserver", null, null);
Console.WriteLine("myNewFolderExists? " + ssFolder);
// Rename myNewFolder to myRenamedFolder.
app.RenameFolderOnSqlServer("\\", "myNewFolder", "myRenamedFolder", "yourserver", null, null);
// Verify that the old folder does not exist.
ssFolder = app.FolderExistsOnSqlServer("\\myNewFolder", "yourserver", null, null);
Console.WriteLine("myNewFolderExists has been renamed but still exists? " + ssFolder);
// Verify that a folder with the new name does exist.
ssFolder = app.FolderExistsOnSqlServer("\\myRenamedFolder", "yourserver", null, null);
Console.WriteLine("myRenamedFolder now exists? " + ssFolder);
// Delete the folder.
app.RemoveFolderFromSqlServer("\\myRenamedFolder", "yourserver", null, null);
// Verify that the folder was removed.
ssFolder = app.FolderExistsOnSqlServer("\\myRenamedFolder", "yourserver", null, null);
Console.WriteLine("myRenamedFolder still exists? " + ssFolder);
}
Shared Sub Main(ByVal args() As String)
' The variable pkg points to the location
' of the ExecuteProcess package sample
' that is installed with the SSIS samples.
Dim pkg As String = "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
Dim app As Application = New Application()
app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", Nothing, Nothing)
' Verify that the folder was created.
Dim ssFolder As Boolean = app.FolderExistsOnSqlServer("\\myNewFolder","yourserver",Nothing,Nothing)
Console.WriteLine("myNewFolderExists? " + ssFolder)
' Rename myNewFolder to myRenamedFolder.
app.RenameFolderOnSqlServer("\\", "myNewFolder", "myRenamedFolder", "yourserver", Nothing, Nothing)
' Verify that the old folder does not exist.
ssFolder = app.FolderExistsOnSqlServer("\\myNewFolder", "yourserver", Nothing, Nothing)
Console.WriteLine("myNewFolderExists has been renamed but still exists? " + ssFolder)
' Verify that a folder with the new name does exist.
ssFolder = app.FolderExistsOnSqlServer("\\myRenamedFolder", "yourserver", Nothing, Nothing)
Console.WriteLine("myRenamedFolder now exists? " + ssFolder)
' Delete the folder.
app.RemoveFolderFromSqlServer("\\myRenamedFolder", "yourserver", Nothing, Nothing)
' Verify that the folder was removed.
ssFolder = app.FolderExistsOnSqlServer("\\myRenamedFolder", "yourserver", Nothing, Nothing)
Console.WriteLine("myRenamedFolder still exists? " + ssFolder)
End Sub
Sample Output:
myNewFolderExists? True
myNewFolderExists has been renamed but still exists? False
myRenamedFolder now exists? True
myRenamedFolder still exists? False
Seguridad para subprocesos
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.
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
Application Class
Application Members
Microsoft.SqlServer.Dts.Runtime Namespace