SSIS "Union Distinct" option
In SSIS, Data Flow tab, we need a component to Union from multiple Flatflies, but make the output DISTINCT before insertion into a database table. I currently have to jump through some extra custom hoops to make this happen.
Thank you for your suggestion! While we aim to respond to every suggestion, we are closing older ones that don’t have enough votes so newer ones from you can move to the top. If this suggestion is still important to you, feel free to open it again.