Append a column to flat file source
Posted on 2009-03-30
Ok, I don't know if I have the most accurate Title for this question, but here goes:
I have a flat file (tab delimited) containing address updates that needs to go to a SQL database.
So, I went ahead and created a Flat File Source and mapped the columns to a OLE DB Data Flow Destination.
Now, in addition to all the colmns in the flat file, say I wanted to map some "static" values to the destination colmns, how would I accomplish this?
For example, I have a column called "Update Source" in the destination table. How would I insert a value in this column if it doesn't exist in the source file without having to create a new column in the source file?