Application.CreateFolderOnSqlServer 메서드
Creates a folder on the specified instance of SQL Server.
네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS(Microsoft.SqlServer.ManagedDTS.dll)
구문
‘선언
Public Sub CreateFolderOnSqlServer ( _
strParent As String, _
strNewFolderName As String, _
strServerName As String, _
strServerUserName As String, _
strServerPassword As String _
)
‘사용 방법
Dim instance As Application
Dim strParent As String
Dim strNewFolderName As String
Dim strServerName As String
Dim strServerUserName As String
Dim strServerPassword As String
instance.CreateFolderOnSqlServer(strParent, _
strNewFolderName, strServerName, _
strServerUserName, strServerPassword)
public void CreateFolderOnSqlServer(
string strParent,
string strNewFolderName,
string strServerName,
string strServerUserName,
string strServerPassword
)
public:
void CreateFolderOnSqlServer(
String^ strParent,
String^ strNewFolderName,
String^ strServerName,
String^ strServerUserName,
String^ strServerPassword
)
member CreateFolderOnSqlServer :
strParent:string *
strNewFolderName:string *
strServerName:string *
strServerUserName:string *
strServerPassword:string -> unit
public function CreateFolderOnSqlServer(
strParent : String,
strNewFolderName : String,
strServerName : String,
strServerUserName : String,
strServerPassword : String
)
매개 변수
- strParent
유형: System.String
The name of the parent folder. If you want to create a folder under the File System node, use the CreateFolderOnDtsServer method.
- strNewFolderName
유형: System.String
The name of the folder to create.
- strServerName
유형: System.String
The name of the instance of SQL Server.
- strServerUserName
유형: System.String
The user name to use when authenticating on the server.
- strServerPassword
유형: System.String
The password associated with the strServerUserName account.
주의
To verify that the folder was created, use the following Transact-SQL query, which selects all packages stored in the File System folder.
select * from sysssispackagefolders
Or, connect to the Integration Services server, expand Stored Packages, and then expand MSDB. The new folder that has the name given in strNewFolderName will be listed.
예
The following code example shows how to create a new folder named myNewFolder. The folder is stored in the sysssispackagefolders table in the SQL Server msdb database.
class ApplicationTests
{
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\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
Application app = new Application();
//Create a folder, myNewFolder, in the
// SQL Server msdb database.
app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", null, null);
}
}
Class ApplicationTests
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\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
Dim app As Application = New Application()
'Create a folder, myNewFolder, in the
' SQL Server msdb database.
app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", Nothing, Nothing)
End Sub
End Class