A Multiple Files connection manager enables a package to reference existing files and folders, or to create files and folders at run time.
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.
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.
|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.|
Configuration of the Multiple Files Connection Manager
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.