Application.RenameFolderOnDtsServer Method
Renames a folder on the specified instance of SQL Server.
命名空間: Microsoft.SqlServer.Dts.Runtime
組件: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
語法
'宣告
Public Sub RenameFolderOnDtsServer ( _
sParent As String, _
sOldName As String, _
sNewName As String, _
sServerName As String _
)
public void RenameFolderOnDtsServer (
string sParent,
string sOldName,
string sNewName,
string sServerName
)
public:
void RenameFolderOnDtsServer (
String^ sParent,
String^ sOldName,
String^ sNewName,
String^ sServerName
)
public void RenameFolderOnDtsServer (
String sParent,
String sOldName,
String sNewName,
String sServerName
)
public function RenameFolderOnDtsServer (
sParent : String,
sOldName : String,
sNewName : String,
sServerName : String
)
參數
- sParent
The name of the parent folder.
- sOldName
The name of the existing folder.
- sNewName
The new name of the folder.
- sServerName
The name of the server where the folder is located.
範例
The following code example creates a folder within the Integration Services services hierarchy, verifies that the folder has been created, renames it, verifies that the old name is still recognized as a folder, and then verifies whether the new folder name is found.
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
Sample Output:
Folder exists? True
Old, renamed folder exists? False
New folder exists? True
執行緒安全性
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.
平台
開發平台
如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。
目標平台
如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。
請參閱
參考
Application Class
Application Members
Microsoft.SqlServer.Dts.Runtime Namespace