Multiple Files Connection Manager
A Multiple Files connection manager enables a package to reference existing files and folders or to create files and folders at run time. The tasks and data flow components in Microsoft SQL Server 2005 Integration Services (SSIS) that can use information in files perform their work by referencing a Multiple Files connection manager that is included in the package.
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.
Usage Types of the Multiple Files Connection Manager
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.
| Value | Description |
|---|---|
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. |
Configuring the Multiple Files 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 Add File Connection Manager.
For information about configuring a connection manager programmatically, see ConnectionManager and Adding Connections Programmatically.
See Also
Other Resources
Integration Services Connections