Use the File Connection Manager Editor dialog box to specify the properties used to connect to a file or a folder.
.gif) Note: |
|---|
|
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.
Concepts
Integration Services Error and Message Reference
Help and Information
Getting SQL Server 2008 Assistance