>>> but it generates SQL that corresponds to the Flat File definition.

I didn't know that. Where is it hiding? Must be the .dtsx package....let me look.

edm2

P.S. We don't let the Business Analysts design our schemas but they are quite involved at the Conceptual level and often have read-only access to production physical databases. as they know the data and business relationships better than a dba.