2 out of 3 rated this helpful - Rate this topic

File Connection Manager Editor

SQL Server 2012

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

Note
You can set the ConnectionString property for the File connection manager by specifying an expression in the Properties window of SQL Server Data Tools (SSDT). 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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions