• I'll have to agree with Phil. Your comment about who was defining tables gave me a bit of a shiver.

    re: item 2, I agree the interface is clumsy but it generates SQL that corresponds to the Flat File definition. I usually will not actually allow the package to actually create the table, I just use the UI to get the SQL and then I go to SSMS to polish it up and create it from there.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato