Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Technical Reference
Feature Reference
 File Connection Manager Editor
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
File Connection Manager Editor

Use the File Connection Manager Editor dialog box to specify the properties used to connect to a file or a folder.

ms177155.note(en-us,SQL.100).gifNote:
You can set the ConnectionString property for the File connection manager by specifying an expression in the Properties window of Business Intelligence Development Studio. However, to avoid a validation error when you use an expression to specify the file or folder, in the File Connection Manager Editor, for File/Folder, add a file or folder path.

To learn more about the File connection manager, see File Connection Manager.

Usage Type

Specify whether the File Connection Manager connects to an existing file or folder or creates a new file or folder.

Value Description

Create file

Create a new file at run time.

Existing file

Use an existing file.

Create folder

Create a new folder at run time.

Existing folder

Use an existing folder.

File / Folder

If File, specify the file to use.

If Folder, specify the folder to use.

Browse

Select the file or folder by using the Select File or Browse for Folder dialog box.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker