Multiple Files Connection Manager

 

Applies To: SQL Server 2016

A Multiple Files connection manager enables a package to reference existing files and folders, or to create files and folders at run time.

System_CAPS_ICON_note.jpg Note


The built-in tasks and data flow components in Integration Services do not use the Multiple Files connection manager. However, you can use this connection manager in the Script task or Script component. For information about how to use connection managers in the Script task, see Connecting to Data Sources in the Script Task. For information about how to use connection managers in the Script component, see Connecting to Data Sources in the Script Component.

The FileUsageType property of the Multiple Files connection manager specifies how the connection is used. The Multiple Files connection manager can create files, create folders, use existing files, and use existing folders.

The following table lists the values of FileUsageType.

ValueDescription
0Multiple Files connection manager uses an existing file.
1Multiple Files connection manager creates a file.
2Multiple Files connection manager uses an existing folder.
3Multiple Files connection manager creates a folder.

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

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

You can configure a Multiple Files connection manager in the following ways:

  • Specify the usage type of files and folders.

  • Specify files and folders.

  • If using multiple files or folders, specify the order in which the files and folders are accessed.

If the Multiple Files connection manager references multiple files and folders, the paths of the files and folders are separated by the pipe (|) character. The ConnectionString property of the connection manager has the following format:

<path>|<path>

You can also specify multiple files or folders using wildcard characters. For example, to reference all the text files on the C drive, the value of the ConnectionString property can be set to C:\*.txt.

You can set properties through SSIS Designer or programmatically.

For more information about the properties that you can set in SSIS Designer, see Add File Connection Manager Dialog Box UI Reference.

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

Community Additions

ADD
Show: