• Calling bcp might be a better option for you than using a Data Flow since bcp does not need to be armed with the table structure if using the bcp out syntax and supplying a table name, e.g.

    bcp DatabaseName.SchemaName.TableName out ...

    You can call bcp from SSIS using an Execute Process Task and use an SSIS Expression to build the command line on the fly, or you could simply call bcp directly and skip SSIS altogether if all you need to do is dump the table to a delimited file.

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