We have a Data Flow task to load a table from one server to another. But the destination has one extra column which I have to pass from a package variable. How I can add it? In a Mapping tab it has an <ignore> drop-down option against this column, but how I can insert my variable instead of this "ignore"?
I already have this variable and tested it with inserting from Execute SQL Task.
I am using OLE DB source and destination.