Analytics in Action

Using the Multiple Flat Files Connection Manager to import multiple files into SSIS.

The Multiple Flat File Connection manager in SQL Server Integration Services allows users to import multiple files using a single connection manager. Using the “*” wildcard also enables all files within a directory to be easily imported.This video demonstrates how to configure a multiple flat files connection manager.

admin

2 Responses to “Using the Multiple Flat Files Connection Manager to import multiple files into SSIS.”

  1. Tempest

    Hi I watched your video and thought I might help me… My issue is I need to load 100s of 1000s of small files that are all the same. Could the multi flat file connection handle that..??