Share via

File Connection Manager Editor

  • Article

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.

Options

  • 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.

See Also

Concepts

Integration Services Error and Message Reference