Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
CreateFolderOnDtsServer Method

Application.CreateFolderOnDtsServer Method

Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy.

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

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

Parameters

sParent

The name of the top level folder to save this folder under.

sNewFolderName

The name to give the newly created folder.

sServerName

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 sysdtspackages90

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);
        }
    }

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.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2015 Microsoft