Wednesday, February 23, 2011

Looping through SQL objects with SSIS

A lady named Barbara wrote this week to say that she'd enjoyed my SSIS Foreach Loop article, but she wondered how one might go about using the Foreach Loop container if the collection was made up of SQL tables instead of files. The procedure is quite similar; the difference lies in using the very useful Foreach ADO.NET Schema Rowset Enumerator to enumerate tables for a given schema.

I figured that the answer to her question, or one possible variant at least, was worth posting on the site, so here it is (PDF, 483KB).

Labels: , ,