Redirect duplicate rows Case I have duplicate records in my source which I want to redirect to a separate destination in my data flow task. Most solutions like the Aggregate…
Flexible XML Destination Case A client wants to export data to XML files, but SSIS has no XML destination. A script component could help him but he doesn't want to create…
Do 'something' for all columns in your dataflow Case If you have a lot columns that all need to be adjusted with the same function (let's say uppercase). You could use the Derived Column compon…