I have a dataflow task in SSIS Package script. When I am updating an input or output column, I would like to propagate the update in the downstream components. Is this a behaviour that is possible to achieve?
Right now if I update the metadata(delete, change the datatype etc) of a column in the dataflow task, the update is not propagated to the downstream components and I have to delete the component and re-add it to get the metadata updated.
Any thoughts or directions for investigations are welcome!