sql server dts: I output 20+ columns to a raw file in one data flow step and read in 5
columns from that file in another (later) data flow step. My task is
to add a 6th column that already exists in the file (and in the
previous RFS definition). My problem is the Advanced Editor for RFS
only shows the 5 columns. It seems pretty simple but I do not see how
to add a column. The "Add Column" option from "Input and Output
properties" results in field mapped to an "external metadata column
that does not exist." Why/How does the RFS default to previously used
mappings, even when deleted and recreated?

I'm an experienced DTS developer but have had some struggles getting
up the learning curve in SSIS. I appreciate any help you can provide.

Regards,
Sean

I have answered my own question but I will post here to close the
thread. I am a little embarrased to admit that I didnt realize the
metadata would be derived from the raw file itself. I fixed my
problem by fixing the creating of the file and then **executing that
step** to create a new file. Then, the metadata flowed through
correctly to the RFS task. Thanks, Sean