Using SSIS to Capture the File Name

Mon, 05 Oct 2009 06:00:00 UT

This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.

Skipping Items in a Foreach Loop

Wed, 23 Sep 2009 06:00:00 UT

Recently, my friend Jack Corbett asked a question on Twitter: In a nutshell, the SSIS foreach loop will enumerate a given...

SQLServerCentral.com Articles tagged For Each Task

Using SSIS to Capture the File Name

Skipping Items in a Foreach Loop