Thanks for the reply. However, what you are doing is different than what I wish to do.
You know in advance the fields that you are selecting from the person table. Meanwhile, I was hoping to use SSIS to dump the contents of a variety of tables with different structures.
Let's say I have a database with many tables that share a common field; e.g., vendor_id. If I know in advance I want data for vendor_id=444, then I can write a query that sticks the names of each table that has a vendor_id field into a temp table. (For example, table1, table2, ..., where each has a vendor_id field.)
Using this temp table (of tables to dump) I wish to use a Foreach container to output the contents of every single table where vendor_id=444. I'd like to have a generic flat file destination connection manager and dynamically load the columns for each new table prior to dumping the contents of it.
Unfortunately, SSIS doesn't allow this. It needs to have the columns for the flat file destination connecton manager defined in advance.
Considering how common the task of making SQL dumps is I'm surprised that SSIS doesn't have a solution for dynamically loading columns into flat file connection managers.
If I'm mistaken about anything please let me know. Again, thanks for the good information.