Use the following technique if you want to extract, transform, and load multiple files matching the wildcard mask.
Step 1. Create a connection for the source files. Make sure the connection supports wildcard filenames.
Step 2. Create a destination connection.
Step 4. Click the
MAPPING button and select the Parameters tab. Check Process all files.