Export (0) Print
Expand All

Application.RenameFolderOnSqlServer 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)

member RenameFolderOnSqlServer : 
        strParent:string * 
        strOldName:string * 
        strNewName:string * 
        strServerName:string * 
        strServerUserName:string * 
        strServerPassword:string -> unit 

Parameters

strParent
Type: System.String
The name of the parent folder.
strOldName
Type: System.String
The name of the existing folder.
strNewName
Type: System.String
The new name of the folder.
strServerName
Type: System.String
The name of the instance of SQL Server.
strServerUserName
Type: System.String
The SQL Server login name if you use SQL Server Authentication to log into the server; otherwise, a null reference (Nothing in Visual Basic) if you use Windows Authentication.
strServerPassword
Type: System.String
The SQL Server login password if you use SQL Server Authentication to log into the server; otherwise, a null reference (Nothing in Visual Basic) if you use Windows Authentication.

The following code example creates a folder on SQL Server, renames it, and then removes it.

No code example is currently available or this language may not be supported.

Sample Output:

myNewFolderExists? True

myNewFolderExists has been renamed but still exists? False

myRenamedFolder now exists? True

myRenamedFolder still exists? False

Community Additions

ADD
Show:
© 2014 Microsoft