Matt Miller (#4) (10/30/2013)

---

Two ways to do this:

1. the SSIS route - use the flat file connector to make SSIS aware of the generic content. then use a conditional split based on column1 to define out multiple mappings to multiple destinations based on your column1 values.

2. SSIS + SQL route. still use the flat file to dump the data into staging (which matches the generic input columns you have). Then run a series of INSERT statements which filter based on the value of column1, e.g.

Insert into MyDest19 (col1, col2, col3, col4, etc....)

Select col1, col2, col3, col4, etc....

from mystagingtable

where column1='Dest19'