Metoda Application.RenameFolderOnDtsServer
Zmienia nazwę folderu na wystąpienie określonego SQL Server.
Przestrzeń nazw: Microsoft.SqlServer.Dts.Runtime
Zestaw: Microsoft.SqlServer.ManagedDTS (w Microsoft.SqlServer.ManagedDTS.dll)
Składnia
'Deklaracja
Public Sub RenameFolderOnDtsServer ( _
sParent As String, _
sOldName As String, _
sNewName As String, _
sServerName As String _
)
'Użycie
Dim instance As Application
Dim sParent As String
Dim sOldName As String
Dim sNewName As String
Dim sServerName As String
instance.RenameFolderOnDtsServer(sParent, _
sOldName, sNewName, sServerName)
public void RenameFolderOnDtsServer(
string sParent,
string sOldName,
string sNewName,
string sServerName
)
public:
void RenameFolderOnDtsServer(
String^ sParent,
String^ sOldName,
String^ sNewName,
String^ sServerName
)
member RenameFolderOnDtsServer :
sParent:string *
sOldName:string *
sNewName:string *
sServerName:string -> unit
public function RenameFolderOnDtsServer(
sParent : String,
sOldName : String,
sNewName : String,
sServerName : String
)
Parametry
- sParent
Typ: System.String
Nazwa folderu nadrzędnego.
- sOldName
Typ: System.String
Nazwa istniejącego folderu.
- sNewName
Typ: System.String
Nowa nazwa folderu.
- sServerName
Typ: System.String
Nazwa serwera, na którym znajduje się folder.
Przykłady
Poniższy przykład kodu tworzy folder w hierarchii usługi integracji usług, sprawdza, czy został utworzony folder, zmienia jego nazwę, sprawdza, czy stare nazwy wciąż jest rozpoznawany jako folder i sprawdza, czy znajduje się nazwa nowego folderu.
static void Main(string[] args)
{
// Create a folder named myOldFolder.
Application app = new Application();
app.CreateFolderOnDtsServer(@"\File System\", "myOldFolder", "yourserver");
// Verify that creation was successful.
Boolean folderExists = app.FolderExistsOnDtsServer(@"File System\myOldFolder", "yourserver");
Console.WriteLine("Folder exists? " + folderExists);
// Rename myOldFolder to myNewFolder.
app.RenameFolderOnDtsServer(@"File System", "myOldFolder", "myNewFolder", "yourserver");
// Verify that the old folder still exists.
folderExists = app.FolderExistsOnDtsServer(@"File System\myOldFolder", "yourserver");
Console.WriteLine("Old, renamed folder exists? " + folderExists);
// Verify that the folder exists with the new name.
folderExists = app.FolderExistsOnDtsServer(@"File System\myNewFolder", "yourserver");
Console.WriteLine("New folder exists? " + folderExists);
}
Shared Sub Main(ByVal args() As String)
' Create a folder named myOldFolder.
Dim app As Application = New Application()
app.CreateFolderOnDtsServer("\File System\", "myOldFolder", "yourserver")
' Verify that creation was successful.
Dim folderExists As Boolean = app.FolderExistsOnDtsServer("File System\myOldFolder","yourserver")
Console.WriteLine("Folder exists? " + folderExists)
' Rename myOldFolder to myNewFolder.
app.RenameFolderOnDtsServer("File System", "myOldFolder", "myNewFolder", "yourserver")
' Check if the old folder still exists.
folderExists = app.FolderExistsOnDtsServer("File System\myOldFolder", "yourserver")
Console.WriteLine("Old, renamed folder exists? " + folderExists)
' Verify that the folder exists with the new name.
folderExists = app.FolderExistsOnDtsServer("File System\myNewFolder", "yourserver")
Console.WriteLine("New folder exists? " + folderExists)
End Sub
Przykładowe dane wyjściowe:
Folder exists? True
Old, renamed folder exists? False
New folder exists? True