Метод Application.CreateFolderOnDtsServer

Статья
04/26/2013

Creates a folder on the server that appears in the Stored Packages node of the Службы Integration Services service hierarchy.

Пространство имен: Microsoft.SqlServer.Dts.Runtime
Сборка: Microsoft.SqlServer.ManagedDTS (в Microsoft.SqlServer.ManagedDTS.dll)

Синтаксис

'Декларация
Public Sub CreateFolderOnDtsServer ( _
    sParent As String, _
    sNewFolderName As String, _
    sServerName As String _
)
'Применение
Dim instance As Application 
Dim sParent As String 
Dim sNewFolderName As String 
Dim sServerName As String

instance.CreateFolderOnDtsServer(sParent, _
    sNewFolderName, sServerName)

public void CreateFolderOnDtsServer(
    string sParent,
    string sNewFolderName,
    string sServerName
)

public:
void CreateFolderOnDtsServer(
    String^ sParent, 
    String^ sNewFolderName, 
    String^ sServerName
)

member CreateFolderOnDtsServer : 
        sParent:string * 
        sNewFolderName:string * 
        sServerName:string -> unit

public function CreateFolderOnDtsServer(
    sParent : String, 
    sNewFolderName : String, 
    sServerName : String
)

Параметры

sParent
Тип: System.String
The name of the top level folder to save this folder under.

sNewFolderName
Тип: System.String
The name to give the newly created folder.

sServerName
Тип: System.String
The name of the server running the Службы Integration Services service.

Замечания

To verify that the folder was created, the following Transact-SQL query selects all packages stored in the File System folder of the Stored Packages package store.

select * from sysssispackages

To view a list of folders, you can also connect to the Службы Integration Services service, expand Stored Packages, and then expand File System. The new folder that has the name given in strNewFolderName will be listed.

To start the Службы Integration Services service, open Control Panel, click Administrative Tools, and then click Services. The Services snap-in opens. Locate SQL Server Integration Services in the list of services, right-click SQL Server Integration Services, and then click Properties, and select a Startup type of Manual. Click OK. Again, right-click SQL Server Integration Services, and then click Start

Примеры

The following example shows how to create a new folder, myFolder, in the File system. To view the folder after creation, open Среда SQL Server Management Studio, connect to the Службы Integration Services service, expand the Stored Packages package store, and then expand the folder named by myParentFolder. In the example, the new folder is created under the existing File System folder.

class ApplicationTests
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            Package p = app.LoadPackage(pkg, null);
    
            // Create a new folder named myFolder on the server named yourserver.
            String folder = "File System";
            String newName = "myFolder";
            String serverName = "yourserver";
            app.CreateFolderOnDtsServer(folder, newName, serverName);
        }
    }

Class ApplicationTests
        Sub Main(ByVal args() As String)
            Dim app As Application =  New Application() 
            Dim p As Package =  app.LoadPackage(pkg,Nothing) 
 
            ' Create a new folder named myFolder on the server named yourserver.
            Dim folder As String =  "File System" 
            Dim NewName As String =  "myFolder" 
            Dim serverName As String =  "yourserver" 
            app.CreateFolderOnDtsServer(folder, NewName, serverName)
        End Sub
End Class

См. также

Справочник

Application Класс

Пространство имен Microsoft.SqlServer.Dts.Runtime

Поделиться через