Export (0) Print
Expand All

Application.RenameFolderOnDtsServer Method

Renames a folder on the specified instance of SQL Server.

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

'Declaration
Public Sub RenameFolderOnDtsServer ( _
	sParent As String, _
	sOldName As String, _
	sNewName As String, _
	sServerName As String _
)
'Usage
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)

Parameters

sParent
Type: System.String
The name of the parent folder.
sOldName
Type: System.String
The name of the existing folder.
sNewName
Type: System.String
The new name of the folder.
sServerName
Type: System.String
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.

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

Community Additions

ADD
Show:
© 2014 Microsoft