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.
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.
|0||Multiple Files connection manager uses an existing file.|
|1||Multiple Files connection manager creates a file.|
|2||Multiple Files connection manager uses an existing folder.|
|3||Multiple 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:
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.