Helaas...deze pagina is niet beschikbaar in het Nederlands. Klik hier om terug te gaan of lees verder in het Engels.

The Foreach Loop Container in SQL Integration Services

Area: SQL Server 2005 | Level: Intermediate

The Foreach Loop container is one of the most flexible and useful controls available to SQL Server Integration Services developers, but the fact that it's relatively poorly documented means that it may not get used as often as it deserves.

In this example I'll describe how I used it to build a workaround for a problem in SQL Server log shipping. Due to low disk space we needed to delete log files as soon as they were no longer needed without changing the log maintenance configuration, but this had to be both automated and failsafe. The Foreach Loop container made this possible. You can adapt this solution for any situation where operations need to be regularly performed on an unknown number of files with no fixed filenames... (continues as PDF)

Download the entire article as a PDF file...
Get a free PDF reader here...