File Connection Manager

A File connection manager enables a package to reference an existing file or folder, or to create a file or folder at run time. Tasks and data flow components in Microsoft SQL Server 2005 Integration Services (SSIS) use information in files to perform their work by referencing a File connection manager that is included in the package. For example, an Execute SQL task can reference a file that contains the SQL statements that the task executes.

When you add a File connection manager to a package, Integration Services creates a connection manager that will resolve to a File connection at run time, sets the File connection properties, and adds the File connection to the Connections collection of the package.

The ConnectionManagerType property of the connection manager is set to FILE.

You can configure a File connection manager in the following ways:

  • Specify the usage type.
  • Specify a file or folder.

The File connection manager can reference only one file or folder. To reference multiple files or folders, use a Multiple Files connection manager instead of a File connection manager. For more information, see Multiple Files Connection Manager.

Usage Types of the File Connection Manager

The FileUsageType property of the File connection manager specifies how the file connection is used. The File connection manager can create a file, create a folder, use an existing file, or use an existing folder.

The following table lists the values of FileUsageType.

Value Description


File connection manager uses an existing file.


File connection manager creates a file.


File connection manager uses an existing folder.


File connection manager creates a folder.

Configuring the File Connection Manager

You can set properties through SSIS Designer or programmatically.

For more information about the properties that you can set in SSIS Designer, see File Connection Manager Editor.

For information about configuring a connection manager programmatically, see ConnectionManager and Adding Connections Programmatically.

See Also


Execute SQL Task

Other Resources

Integration Services Connections

Help and Information

Getting SQL Server 2005 Assistance