File Group Pattern (Model Object)

Description

The Property named File Group Pattern is available only when you edit a Source Model Object in the Microsoft SQL Server - Stage File generator.

It allows you to specify the pattern for loading multiple files simultaneously.

This pattern can include the placeholder characters * to match any number of characters and ? to match any single character.

Let's take the following source file example:

To load all the files starting with T, I will set the File Group Pattern Property to T????.

Then I have an increment number, in this example, 1000 to 2002.

To load multiple files simultaneously, their names must respect a common pattern and include an increment (number, date...).

Format

The File Group Pattern is a String.

Example:

Default Value

The default value is *, which means all the files are loaded from the source folder.