• Developing custom data flow component is not pretty. May I ask you how would you know which columns are mapped to which destination table columns? Are you going to have a special control table with metadata? Perhaps there might be another solution available.

    Another question can you elaborate in what data flows you want to use this component? Is it straight transfer or you have different transformations preceding this destination table?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/