O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Foreach Loop Container: looping through files using File Enumerator

The most common type of enumerator, the Foreach Loop Container with file enumerator, is used in this recipe. This type of container loops through a list of files in the filesystem and executes some type of action that should be taken inside the respective container.

If a connection exists inside this container, an essential configuration associated with this container type is to pass this connection dynamically creating the connection string based on expressions with the filename provided by the container and read in each execution.

Getting ready

To get ready for this recipe, use the following steps:

  1. Open SQL Server Data Tools (SSDT) and create a new SSIS project.
  2. Provide a name and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required